Free Macros
No | Macro Name |
1 |
Open a txt file on a sheet / page and import its contents the name of a txt file is the sheet / page name |
2 |
Draw a box / shape in excel |
3 |
Add toolbars to combo box and select from there |
4 |
Select cell |
5 |
Update manually |
6 |
Return enter key |
7 |
Check the same data on the active sheet / page |
8 |
Worksheetthis macro code will help you easily control and manage worksheets and save you a lot of time. Hide all except active worksheet: now if you want to hide all worksheets other than the active worksheet in your workbook, say. This macro code does this for you. |
9 |
Coloring sheet / page names |
10 |
Adjusting the screen resolution |
11 |
Adding characters to the end of the formula |
12 |
Records detailed formatted cells on the records sheet / page |
13 |
If cell a1 is 1, the message box should start and write the excl. |
14 |
Userform 5 term userform-2 |
15 |
Macro corresponding to etopla formula |
16 |
3 x shaped warning messages |
17 |
Macro that locates the searched word and clears that line |
18 |
Column a separates the same value as the print area |
19 |
A macro with rows and columns |
20 |
Hide sheet / page |
21 |
Apply names dialog window |
22 |
Delete all pictures |
23 |
Userform 7 prompts userform when crossed |
24 |
Add image dialog window |
25 |
Numbers that are the same |
26 |
Invalid warning message exiting userform with x |
27 |
Open dialog window |
28 |
Message box samples |
29 |
Scans sheet / pages and prints previews if data is available |
30 |
A1e force to enter date with vba |
31 |
Gallery pie dialog window |
32 |
Prints the name of the active workbook in the active cell |
33 |
Selecting all of the content when the textbox is clicked |
34 |
Same sheet / page warning |
35 |
Enter cancel on sheet / page |
36 |
First letters in cell capital 2 |
37 |
Deletes empty rows below the active cell |
38 |
Adds months as a sheet / page and writes the days of the month and goes to the active month and day |
39 |
Format graph dialog window |
40 |
Change formula dialog window |
41 |
Click-to-listbox |
42 |
Selects from top to bottom if the column contains data |
43 |
Custom header / footer: this code is for you if you want to add a custom header. In the run this code entry box, enter a custom value. You can edit the code to change the alignment of the header or footer. |
44 |
Comparison example with combobox |
45 |
Cut cancel & open copy |
46 |
Column transfer month |
47 |
Dialog window "set tuple editor in columns" |
48 |
Com. Ver from the form box to the lis. Box |
49 |
Row sorting |
50 |
Write your name with file backup message box |
51 |
Interest calculation |
52 |
Collection with textboxes |
53 |
About listbox |
54 |
Api to create shortcut to my excel file on desktop |
55 |
Assign a total to a variable v. |
56 |
Opening system date |
57 |
Detection of a region named with the name manager / is there such a name given anywhere? |
58 |
To delete sales with faulty cells |
59 |
Adds todays date to the active cell |
60 |
Highlight active row and column: highlight active row and column |
61 |
Copy and paste with macro |
62 |
Msgbox according to condition |
63 |
Name the active cell or selected cells |
64 |
Make the first letter of all words in the selected region capitalized and the other letters lowercase |
65 |
How many jpg files are in the folder? |
66 |
Select the most recent cell |
67 |
Label ranges insert window |
68 |
File backup |
69 |
Only one view of data in the combobox |
70 |
If a5 = 2, do not open the userform |
71 |
Cells colorful flashes |
72 |
Save as you want to keep coming |
73 |
Timer message example |
74 |
Calculate how many sheet / pages are there |
75 |
Sheet / page showing at opening and not appearing at closing |
76 |
Deleting empty rows2 |
77 |
Transfers full ones to another sheet / page |
78 |
To make an empty cell the same as an upper cell |
79 |
Inserts months as sheet / pages specifies days in detail |
80 |
Adjust the screen resolution |
81 |
Merge two separate columns with data |
82 |
Slicing settings dialog window |
83 |
Codes that prevent the cursor from moving when the macro is running |
84 |
Importing filled ones from cell into listbox |
85 |
Textbox date example |
86 |
Whether to print straining 2 |
87 |
Show all rows and columns: you can use this code to do this one at a time, rather than overwriting individual rows and columns. |
88 |
Enable a1 reference style: this macro code will help you enable the a1 reference style without using the excel options. |
89 |
Protection protection menu |
90 |
Importing data from a sheet / page in the listbox |
91 |
Write e1 cell and e15 cells total a1 e |
92 |
Counting voices in textbox |
93 |
Takes dated backup to current folder |
94 |
Sheet / page protection and removal |
95 |
A cell that we want to be active when pressed |
96 |
Undergraduate program |
97 |
Selects the rows where the selected cells are located. |
98 |
Shutdown and restart the computer |
99 |
Add new toolbar |
100 |
Informs you which sheet / page is active when you move from sheet / page to sheet / page |
101 |
Clock in cell a1 |
102 |
Translate text to cell event from userform |
103 |
Select tab and textbox content |
104 |
Calculate the duration of the mp3 file (type the file path and select that cell) |
105 |
Click any cell and scroll to the right to write the number of days in that month |
106 |
Enlarging |
107 |
Learning the file format of the drive |
108 |
Format text dialog window |
109 |
Update automatic |
110 |
Automatic filter opening |
111 |
Add multiple columns: after running this macro, you will show an input box and you must enter the number of columns you want to insert. |
112 |
Makes all selected cells 0 |
113 |
Sheet / page protect unprotect |
114 |
Day date time in message box |
115 |
Select a print area |
116 |
Moon learning in cell (defining function) |
117 |
Assign value to cell |
118 |
Who opened the file 2 |
119 |
List sheet / page names from a1 |
120 |
Select value in combobox |
121 |
Email window of active book |
122 |
Show all hidden sheet / pages |
123 |
Delete selected data and row in combobox |
124 |
References control |
125 |
Import sheet / page names into listbox |
126 |
Copies the sheet / page and creates a sheet / page dated yesterday and assigns the information into it |
127 |
Double record blocking. |
128 |
Hello when the program opens |
129 |
History transactions 1 |
130 |
Transfer from combobox to sheet / page |
131 |
Form calls |
132 |
Disable add-in in xla file |
133 |
Magnifies the screen of the opened book |
134 |
Text animation |
135 |
If you enter data between a1-a20 |
136 |
Set the showmodal status by writing code. |
137 |
Output as a word sheet / page |
138 |
Convert formulas to value |
139 |
Printing sequence numbers to comboboxes |
140 |
Delete a file on the computer |
141 |
Email selected cells |
142 |
Change connection dialog window |
143 |
Lock the book. Speak read - only read - only. Hides macros |
144 |
Repeated registration warning |
145 |
Manage relationships dialog window |
146 |
Is the size of a file in bytes? |
147 |
One click output |
148 |
Prints the name of the workbook and active sheet in the active cell |
149 |
Close all forms showmodal false ones 1 |
150 |
Separating merged cells with macro |
151 |
Adding date to a1 when closing book |
152 |
Clearing the clipboard after a copy command |
153 |
Date and time in label |
154 |
Get information from the registry |
155 |
Excel file working on cd |
156 |
Processes the opening date and time of the file in txt (bottom to bottom) |
157 |
Special expense discount macro |
158 |
Code that finds the number of sheet / pages 1 |
159 |
Cancel copy and paste |
160 |
Warning message 4 x shaped warning window |
161 |
If the value of cell a1 is lower than the value in cell a3, let macro work |
162 |
Opening calculator |
163 |
Subfolders |
164 |
Exit procedure |
165 |
Workbook options dialog window |
166 |
Data transfer... |
167 |
Multisheet / page encrypted switch |
168 |
Remove decimals from numbers: this code helps you remove all digits of the digits in the selected range. |
169 |
Assigning macros to the f9 key |
170 |
Detecting whether there is an extension (or not in the excel library? ) |
171 |
Msg box alarm in 3 sec |
172 |
Web options pictures dialog window |
173 |
Which day is the answer to the question which day |
174 |
Wmi windows |
175 |
Adding the commandbar |
176 |
Import file |
177 |
User-defined (sheet / page count) |
178 |
Close all forms showmodal false ones 2 |
179 |
Stop clock if b1 x |
180 |
Add a comment to the active cell and set the font and point for that comment |
181 |
Adding additem to the listbox with a "for" loop |
182 |
Moves to the selected cell |
183 |
Writes the names of all sheet / pages from the active sheet / page and cell and adds a link to the sheet / pages |
184 |
Find-change-delete-save macro |
185 |
Color active cells |
186 |
Moves to the blank row below the last full row in the column |
187 |
Save and close book automatically |
188 |
Three cell jumps of the cursor |
189 |
Finding a birthday |
190 |
C lists folders in the listbox |
191 |
Column width set 5 |
192 |
Trading with a single userform |
193 |
Textbox and combobox |
194 |
Still userform |
195 |
Comparison; sheet / page1 sheet / page2 abc columns |
196 |
Save a book by name |
197 |
Print inside cells with a certain print area but only filled |
198 |
Collapse column by data in cell |
199 |
Bear automatically recognizing codes |
200 |
Recall the notebook |
201 |
Sparkline adding win loss dialog window |
202 |
Mail logon dialog window |
203 |
Using a macro to copy a module to another location |
204 |
Adds a new sheet / page named month and year, together with the data a1: a5 |
205 |
Sheet / page names |
206 |
Macro to hide the sheet we will write to open the macro to ask him to know the password |
207 |
Fills the line spacing on the sheet / page |
208 |
Add sheet / page write name to inputbox |
209 |
Flashing articles |
210 |
Print by increasing the value in the cell by 1 |
211 |
Adding formulas to different cells |
212 |
Menu editor dialog window |
213 |
Convert day to day: if you have a date on your worksheet and want to convert all these dates into days, this code is for you. Just select the range of cells and run this macro. |
214 |
Assign file names to excele |
215 |
Protects your worksheet works automatically filters |
216 |
If the condition is satisfied |
217 |
Warns and deletes data when data is entered in the active sheet / page |
218 |
Retrieve data from an encrypted closed file |
219 |
Formula replication by full row |
220 |
Gaps between sequence numbers c5: c20 |
221 |
Hides blank lines on a sheet / page |
222 |
Excel fonts |
223 |
Putting and removing protection on the active sheet / page |
224 |
Does excel drawing? |
225 |
Delete our file |
226 |
Msgbox warning |
227 |
Update a pivot table |
228 |
Hiding external rows in colored cells |
229 |
Open window |
230 |
First letters of textbox are capitalized |
231 |
Link to a1 and open outloook with mail in a1 |
232 |
Guide lines dialog window |
233 |
Userform 3 hides the close button on the top right of userform |
234 |
Conditional formatting window |
235 |
Flashing |
236 |
Convert range as image: paste the selected range as an image. Just select the range, and after running this code, it automatically adds an image for that range. |
237 |
Hide all sheet / pages except sheet / page 1 |
238 |
Opening all excel files with 85% |
239 |
Refresh information in pivot table 1 |
240 |
Find the last cell before a space in the row |
241 |
Moves the selected cell to the upper left corner |
242 |
Processor speed |
243 |
Delete a cell from a sheet / page in another book |
244 |
Make sheet / page names in excel file invisible |
245 |
Save and close completely |
246 |
Cell |
247 |
Cell selects specific active line |
248 |
Sheet / page names in alphabetical order 2 |
249 |
Save as cell name a1 |
250 |
Errorbarx dialog window |
251 |
Hide the desired column |
252 |
Finding the day of the week n. |
253 |
Double-clicking on listbox and retrieving values from textboxa listbox columns |
254 |
Errorbary dialog window |
255 |
Sorts unordered names in column a of sheet / page 1 to a-z in column a of sheet / page 2 |
256 |
Internet with internet explorer on sheet / page |
257 |
Put a leading character in the listbox |
258 |
When i select the same number at the bottom of the order, i want the information of the selected number to be imported into the textbox. |
259 |
Run macro when cell changes (expression in value, etc. ) / run macro when cell changes |
260 |
B2c2d2 takes the date in a2 as day month month year |
261 |
Rounding formula in cells 2 |
262 |
Add excel sheets as menus |
263 |
Protects formulated cells |
264 |
Inserts any number of rows from the active cell |
265 |
Record on multiple sheet / pages with the same macro |
266 |
Opening with the same sheet / page |
267 |
Selects full cells and converts them to uppercase |
268 |
Labelde date format |
269 |
Term userform 2 |
270 |
Select sheet / pagename if it exists from the sheet / page and continue processing on the sheet / page, if not, it will open a new worksheet under sheet / pagename |
271 |
Explanation of the formula |
272 |
B3e enter data insert web sheet / page as sheet / page |
273 |
Write to the cell delete the range of data to be deleted (deletes from sheet / page1 and sheet / page2 on sheet / page1 to a2b2) |
274 |
Select cell values with auto-color in specific table |
275 |
Deletes duplicate records (duplicate records) |
276 |
Print area |
277 |
How many (number of drive) |
278 |
Create your own extensions and functions in excel |
279 |
Adding a-z alphabet in a range: you can add alphabets to your worksheet as you do serial numbers. You can find the code below. |
280 |
Dialog window "color palette" |
281 |
Receive alerts when changing data |
282 |
Another command instead of "wait" |
283 |
Sum of numbers in listbox in textbox |
284 |
The value passed from the listbox to the textbox is output in the same format |
285 |
Remove the formula bar |
286 |
Data scrolls |
287 |
Automatic uppercase letter 3 in textbox (for turkish character problem) |
288 |
Finding the number of each item in the list using the vba and pivot table |
289 |
Summer adds months to sheet / pages |
290 |
Sort sheet / pages by a-z or z-a |
291 |
Opens and copies the selected word document |
292 |
Detailed report on harddisk |
293 |
Ping the address in the cell |
294 |
Commadbuton creation macro |
295 |
Update pivot tables in all open excel files |
296 |
Disables the close button at the beginning of the userform (userform does not close when multiplied) |
297 |
Save optional data to sheet / pages |
298 |
Save only worksheets |
299 |
Conditional data entry into textbox |
300 |
Number finding |
301 |
Round number 3 |
302 |
Find-delete-change-save codes2 |
303 |
Words from an entire worksheet: can help you count all the words in a worksheet. |
304 |
A1 = 1 c1 = 3 column b be hidden. Sheet2 is a1 = 1 b1 = 3 |
305 |
It doesnt delete even if a row is full in any column of the active row. |
306 |
Add date and time in two clicks |
307 |
Close one form and open another |
308 |
Listing sheet / page names (tab name) |
309 |
Adds intermittent ones in column c |
310 |
Adds 1 to the numbers in column a writes to column c |
311 |
Scroll bar properties dialog window |
312 |
Rename the additem in the listbox |
313 |
Deletes the top empty cells from the last full cell on the worksheet |
314 |
Find macro |
315 |
Zoom in / out or reduce the active sheet / page to a certain size |
316 |
Loop |
317 |
Number / highlight cells that error in the entire worksheet: this code will help you to highlight and count all the cells you have made an error with. Just run this code and it will return a message containing the number error cells and will highlight all the cells. |
318 |
Excel operators hk |
319 |
Listing colors |
320 |
Ignore book title a1 |
321 |
Non-movable userform |
322 |
Time counter |
323 |
Go to related sheet / page |
324 |
Automatically opening the column at the desired width when you click on the cell |
325 |
Show changing cells |
326 |
Adding and deleting jpeg images |
327 |
Userforma adds a minimization and maximize button |
328 |
Double-line message box 3 |
329 |
Performance test |
330 |
Dialog window |
331 |
Sheet / page names in alphabetical order |
332 |
Sorting of filters in combobox |
333 |
Off without saving |
334 |
Makes workarea1 0 |
335 |
2 move data between listboxes |
336 |
Add dialog window |
337 |
The macro only works with the current file |
338 |
Enter date in a1 to find out what week is in b1 |
339 |
Entering the data in the listbox (ie without mouse) |
340 |
You have 3 rights to the encrypted login. |
341 |
Calculator on / off |
342 |
Userforma adds a minimization and maximize button |
343 |
Cancellation of menu and commands cannot be selected |
344 |
Opening a file and entering data |
345 |
Comboboxa manual data entry prohibited 2 |
346 |
Return to form when preview closes from userform |
347 |
Add-remove button |
348 |
Dictionary codes |
349 |
Prints selected areas on a sheet of paper |
350 |
Customization and return of toolbars |
351 |
Function codes that find out what week |
352 |
A1: j44 hiding external cells |
353 |
Leaves 1 space between words |
354 |
Entering data in msgbox la a1 |
355 |
Find-delete-change-save codes |
356 |
Module deletion |
357 |
Let macro run automatically if column 4 is executed |
358 |
Cell format is the same as in the textbox |
359 |
Give background color by number on active sheet / page2 |
360 |
First full cell from right to left |
361 |
Merge window |
362 |
Variety dialog window |
363 |
A1 to each data entry b1c1 respectively, always writes to the side column |
364 |
New webquery dialog window |
365 |
Txt who opened the file on what date |
366 |
Open and close notebook |
367 |
Copy-paste blocking |
368 |
Password opening |
369 |
Does not enter a smaller value in the active cell |
370 |
Opening dataform |
371 |
Select column to say the number of full data |
372 |
Collect thick ones |
373 |
Print full area |
374 |
Open the text box with the button to transfer data |
375 |
Macro for seeing vba codes |
376 |
Animated gifs userformda |
377 |
Message box caption |
378 |
For quick information entry on any sheet / page |
379 |
Import the active cell into listbox and textbox (using spinbutton) |
380 |
Delete rows |
381 |
Include header / footer date: use this code to add a date to the header or footer of your worksheet. You can edit this code to switch to the header footer. |
382 |
Output from the printer as many as the number in the cell |
383 |
Book every opening a1 1 increases |
384 |
Hide and show from 10th line |
385 |
Automatic fit of text width in description |
386 |
Selects from the active cell to the right |
387 |
Share workbook window |
388 |
Object assignment dialog window |
389 |
Delete cells that are the same as the macro |
390 |
Book opening-copying-closing |
391 |
Saving output |
392 |
Sorts the sheet / page names as they are |
393 |
Finds data |
394 |
Easy menu with right mouse |
395 |
Custom sort dialog window |
396 |
Cd on and off |
397 |
Alignment window |
398 |
Forecastets dialog window |
399 |
Window vertical splitting 2 |
400 |
B3 type and collect 10 pieces |
401 |
Phone format in textbox |
402 |
Paste names dialog window |
403 |
Open a word document |
404 |
Macro with hold |
405 |
I want it to be white so that it doesnt appear on the printout. |
406 |
Calls the browse folder window |
407 |
Sheet / pages showing userform (with code without form) |
408 |
Combobox can not get data a... |
409 |
Select the region table area |
410 |
Paste cells as values |
411 |
Shift selected cells down. |
412 |
If we want the value of dtpicker to be a value from the database |
413 |
Type in cell and make your font bold |
414 |
Write to side cell |
415 |
Automatic collection process |
416 |
Copy paste |
417 |
Breaking sheet / page protection |
418 |
New line code |
419 |
If action is performed in cell a1, cell a2 writes the modified date and time |
420 |
Api that finds which key is pressed |
421 |
Textboxes are not empty |
422 |
Copy and paste operations |
423 |
General options window |
424 |
Macros that determine and cancel your workspace on your worksheet |
425 |
Date format in textbox |
426 |
; show all hidden sheet / pages and make them visible |
427 |
Pie diagram drawing |
428 |
Run macro codes when you enter values to a1 |
429 |
Only the print area down is selected even if there is only one cell |
430 |
Warning message (anytime, anywhere) |
431 |
Show sheet / page tabs in cell |
432 |
Find the most recently used cell in a column |
433 |
Convert formulas to numbers |
434 |
Subscribe dialog window |
435 |
Random numbering |
436 |
Pivot calculated area dialog window |
437 |
Delete files |
438 |
Click on any cell to run the macro |
439 |
Copy textbox content |
440 |
For example, if macro is executed in line 4 |
441 |
Do you want the active cell to go to the top of the sheet / page? |
442 |
 pivot table these codes help you make and manage some changes to pivot tables in a flash. Hide pivot table subtotals: if you want to hide all subtotals, simply run this code. First make sure that you select a cell from the pivot table and run this macro. |
443 |
Message if textbox2 is greater than textbox1 2 |
444 |
Sheet / page address and set column width |
445 |
Time difference calculation |
446 |
To play a wav file in your current directory |
447 |
Calls sheet / page protection menus |
448 |
Date format in active sheet / page and target cells |
449 |
Is there one or more fields in the selected field? |
450 |
Userform 2 minimizing userforma and adding maximize button |
451 |
Allows textbox and numeric and backspace |
452 |
Thousands separator in textbox |
453 |
Set the font thickness |
454 |
Combination dialog window |
455 |
Learning screen resolution |
456 |
Selects from right to left if there are values in 2 cells next to each other |
457 |
Print hidden sheet / page |
458 |
View dialog window |
459 |
Draw a border by cell width |
460 |
Collects cells that are red between a1: d20 |
461 |
If more than 2 characters are written in the textbox, it will switch to the other textbox |
462 |
Read the number in dollars = dollartext (a1) |
463 |
Book opening (more than 1 file) |
464 |
Select cell identification |
465 |
Prevent saving excel file |
466 |
Print preview dialog window |
467 |
Register with textboxes |
468 |
List sheet / page names 2 |
469 |
Selects the first empty cell after full cells. (for columns. ) |
470 |
Adds sheet / pages based on data in column a and writes data up to column d |
471 |
Just select the cells used (region) |
472 |
Copy data to textboka |
473 |
Data limitation in textbox (max characters) |
474 |
In the deletion of the last written sheet / page, type the following code in the exit button. |
475 |
Selects from the active cell to the left |
476 |
Create a user-defined menu / create your own menu and assign a macro to them in the "extensions" section |
477 |
The data you receive in combobox is changed to big week |
478 |
When you enter a value of a1 multiply by 10 write to a2 |
479 |
Hiding |
480 |
Capitalize sheet / page names |
481 |
Import the comment in the cell into the textbox |
482 |
Does the macro work on the hidden sheet / page |
483 |
X-shaped warning window |
484 |
Dyes empty cells between cells a1: a10 |
485 |
Double-click the address in the listbox and the form closes |
486 |
Collection in textboxes |
487 |
Convert date to years: this code converts dates into the year of the month. |
488 |
Save as with name in a1 |
489 |
The selected region consists of how many different areas (squares) |
490 |
Frees table |
491 |
Create shortcut to desktop |
492 |
Commandbutton escapes not clicking anymore |
493 |
Shows sheet / page2 hides (2 clicks in sequence) |
494 |
Password before saving |
495 |
Finds how many rows are selected |
496 |
Delete the line that is registered with the help of the button |
497 |
Open my documents folder with alt + f4 |
498 |
Double-line message box 2 |
499 |
Gives the address and type of formula if the active cell contains a formula |
500 |
Bring some of the tool buttons as a separate menu at boot |