Free Excel Macros (VBA)


Enter keywords related to the macro you are looking for.

Free Macros
NoMacro Name
1 Convert from row to column
2 Takes dated backup to current folder
3 Open a workbook and retrieve data from column a
4 Hiding external rows in colored cells
5 Double-clicking on the listbox and deleting from and from the listbox
6 Clock date functions
7 Form calls
8 Â Â and column hiding process of your workbook
9 Learn the number of sheet / pages in the message by opening
10 Save only worksheets
11 Copy chart dialog window
12 Menu editor dialog window
13 Userformda calendar
14 Show all pivot table fields
15 New document opening window
16 Encrypt the whole book-you give the password
17 1 more than 1 in the list
18 Gallery 3d line dialog window
19 Delete sheet / pages other than specific sheet / pages
20 Close my workbook with a button on my sheet / page
21 Filtering by color in the cell
22 Column finds full cells and encapsulates print area
23 Undergraduate program
24 Refresh information in a pivot table 2
25 Gallery 3d column dialog window
26 Save as you want to keep coming
27 Midi playback
28 Add function window
29 Macro2 when cell is empty macro2 when full
30 Finds the largest value in selected cells and makes them bold
31 Message box: message boxes with ok and cancel options
32 Delete rows that match a specific criterion
33 Toggle button creation and command
34 Print and number the sheet / page to the desired number...
35 In the cell next to the month (according to the data in the abc column)
36 Exiting excel file without saving closing without saving
37 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.
38 Deletes formats in selected cells
39 Delete names defined on a sheet / page
40 A value in the combobox is already selected
41 Seconds message in statusbar
42 Format text dialog window
43 Moves the selected cell to the upper left corner
44 New workbook dialog window
45 How many times has the file been opened
46 Patterns dialog window
47 Conversion from formula to value
48 Create shortcut to desktop
49 Date and time in a label
50 Record on multiple sheet / pages with the same macro
51 Sorts the sheet / page names as they are
52 Entering data into the desired cell
53 Collect thick ones
54 You can change the column selection by modifying the value in the macro ("c: c")
55 Userformda date
56 Thousands separator in textbox 2
57 Go to related sheet / page
58 Sorts the numbers in column a (even if one of the tweens is deleted) 2
59 Protection protection menu
60 Print the cell
61 Move workbook dialog window
62 Enable a1 reference style: this macro code will help you enable the a1 reference style without using the excel options.
63 Make a cell currency
64 Rows and columns set in cm
65 Friends textbox enter the text by pressing the enter key im doing a carriage return. But after each enter, i see that what can i do to prevent these squares that have formed [] frames in the cell
66 Set the font thickness
67 Row deletion
68 Reset checkboxes in userform
69 Comparison example with combobox
70 Deletes duplicates in column b
71 The number formatted in textbox appears in the same format in the cell
72 Collection in textbox
73 Prints the name of the active workbook in the active cell
74 Transfer data from listbox to sheet / page
75 Sorts data and finds name
76 Reference types when printing a formula to a cell
77 Defining list in combox
78 Column width set 5
79 Closing all open books
80 Move to target cell
81 ; a to z order / letter order by name of sheet / pages
82 Apply names dialog window
83 Make the visual basic project access trust checkbox true.
84 Key in the inbox
85 Day date time in message box
86 Returns the number of rows for the selection.
87 Add quick access to custom lists. Add custom list access to the right-click menu
88 List all toolbars
89 If cell a1 is greater than zero, let the macro run.
90 Write to side cell
91 Summer adds months to sheet / pages
92 Remove the formula bar
93 Vba insert file dialog window
94 Double-click on active cell to add subtotal
95 Show hidden description (select cell)
96 For quick information entry on any sheet / page
97 Create marquee in excel cell
98 Delete an image on a sheet / page
99 Which cell you want to go to by scrolling
100 Vlookup formula or function with 3 (three) parameters
101 Deletes blank lines in your worksheet
102 Show drive serial number
103 Gallery radar dialog window
104 Collect columns a b write cye
105 Does the macro work on the hidden sheet / page
106 Delete all rows with column c blank
107 A16: selects g28 cells and sets to 0
108 The number entered in the cell in the description (12300)
109 Name
110 Prints desired cells vertically
111 Del key should not work in column 2
112 How many jpg files are in the folder?
113 Macro run every 5 minutes
114 Identifying unique (single) data entries
115 Type b1 from a1 to sequence number
116 Write the number of columns and give the column name as a letter (ktf)
117 Learning button name on sheet / page
118 Hard disk formatting
119 Sort sheet / page names from z to a
120 Run macro on cell
121 The value in the inbox is transferred to the key
122 Height of the next line after every 5 lines 5
123 Sheet / page protected if b2 is blank
124 Deletes the top empty cells from the last full cell on the sheet / page
125 Force
126 Extract dialog window
127 Hide or show the formula bar
128 Does excel drawing?
129 Recommended pivot tables dialog window
130 Finds how many rows are selected
131 Allows textbox and numeric and backspace
132 Mini email
133 History transactions 1
134 Full screen normal screen
135 Dialog window "add toolbars"
136 Determine whether the cell is empty
137 What is chr
138 Selecting tab and textbox content 2
139 Change the color of a cells font
140 Show all rows and columns: you can use this code to do this one at a time, rather than overwriting individual rows and columns.
141 Penny in the textbox 1
142 Address of the current cell (example g3)
143 Search macro
144 Hide all sheet / pages 1 sheet / page must appear
145 Date collection subtraction error in textbox
146 Opens sheet / page by month name and copies active sheet / page
147 Formulated cell colored
148 Message or macro according to the value in the cell
149 Find and open excel files in file path
150 Transfer from combobox to sheet / page
151 Sort sheet / pages a to z
152 Delete rectangle on active sheet / page
153 File sharing dialog window
154 Detailed active cell address
155 Obey the commandbutton in userform3 according to the terms.
156 Main chart type dialog window
157 Calculation dialog window
158 Forms do not allow x to exit
159 Delete an excel (xls) file
160 Wmi windows
161 Book name in the lower left corner of the custom footer sheet / page1
162 Restoring old formulas (renewal of formulas)
163 Open a word document
164 Color change when i come to the buttons with the mouse
165 Gif vs. Jpg picture insertion
166 Started tripping
167 Make the first letter of all words in the selected region capitalized and the other letters lowercase
168 Makes sheet / page horizontal and prints cell a1
169 Save the file as dated
170 Split dialog window
171 Save each sheet / page separately as a book
172 Edit all dialog window
173 Dialog window
174 Column transfer month
175 Email inquiry in textbox
176 Reporting problem
177 Shut down computer with macro
178 Macro that locates the searched word and clears that line
179 Count / highlight cells with a specific feature on the entire worksheet: this code will help you count the cells that have a specific value to mention, and then highlight all of those cells.
180 Increasing the number of cells called numfact on opening and closing
181 Double-line message box 2
182 Codes to manually select the rows and columns you want to print
183 Storing data as a report
184 Receive a message after each data entry
185 Show all hidden sheet / pages
186 Number of days in the cell
187 Close
188 Time difference calculation
189 Dialog window "check box properties"
190 Learn your screen resolution
191 Dialog window
192 Inputbox add year as summer
193 Send list by excel
194 Tax refund calculation
195 Saving and sorting alphabetically
196 Prints the active sheet / page
197 Using format painter to fit the format into a specific cell
198 Write to the bottom cell if the number of letters is more than 100 1
199 Number finding
200 Search combobox change
201 Convert small case: this code helps you convert selected text to lower case text. & nbsp; select a range of cells that contain your text and run this code. If a cell has any value other than a number or text, the value will remain the same.
202 Background flashes
203 Index cells vba code
204 Specify row height and column width in cm
205 Find out if there is a formula in the selected cell
206 A cell with a formula
207 Update manually
208 A code that gives the full directory name
209 Change the background image then do none
210 Format cell / fonts window
211 Whatever macro you press
212 Mail next letter dialog window
213 Userform click x to close excel
214 Module deletion
215 Open a new file with the "open file" window
216 Round number 1
217 Fetch sheet / page name with function
218 Insert and run the antidote procedure in the following link.
219 If the value of cell a1 is lower than the value in cell a3, let macro work
220 Run dialog window
221 Worde data transfer
222 Pushbutton pictures
223 Search for a word in 30 excel files
224 Block save as
225 Write the same cell in all cells on the active sheet / page
226 Custom paste dialog window
227 Entering data in msgbox la a1
228 Displaying numbers in text
229 For the largest number in column a
230 Clicking column c expands and narrows when you click another cell
231 Active letters
232 Learning whether the book is open by function
233 Specifies in detail how many references the book contains (on new sheet / page)
234 Display names in a1 in the listbox
235 Number of outputs by inputbox 2
236 Transformation of formulas in cells 2
237 Iteration of pivot table data
238 Update selected pivot table
239 Macro to hide the sheet we will write to open the macro to ask him to know the password
240 Beep every second
241 Deletes data
242 Run individual macros based on active sheet / page
243 Does the macro work on a protected sheet / page?
244 Add sheet / pages as menus
245 B3e enter data insert web sheet / page as sheet / page
246 Create new line in message box
247 Apply a1: h1 to other sheet / pages
248 Write sheet / page names from a1
249 Encrypted entry is a number from 0-254
250 Scrolling
251 Calculate cube root: you can use this code to calculate the cube root without applying a formula. Checks all selected cells and converts numbers to cube roots.
252 Cell
253 Change the message text written in macro
254 Style window
255 Filter 2 date ranges in comboboxes listbox
256 It takes data from "listbox a" and then writes "textbox b"
257 Delete text file 2
258 Double-clicking on listbox and retrieving values ​​from textboxa listbox columns
259 Change connection dialog window
260 Automatic separating numbers in textbox with a point in three digitals
261 Size dialog window
262 Lock userform 2
263 Sheet / page naming
264 Transformation of formulas in cells 1
265 Userform to cell
266 Print out the specified range of cells
267 Password before saving
268 Active or passive command button according to the conditions
269 Hide blank lines
270 Copying entire folder
271 Nam definitions given to cells
272 Textbox character restriction
273 Prevent changes in print preview
274 Print the user name in cell a1
275 Opens rows on sheet / page
276 Translating all rows of selected cells.
277 Detecting whether there is an extension (or not in the excel library? )
278 Reverse text, rewrite from end to top
279 Add a formula to a cell
280 Open auto filter (filter)
281 Customize commands window
282 Treeview
283 Clock format
284 Minimizing active workbook windows
285 Column headers rc style and normal style
286 Different warning windows
287 Transfer empty cells from column b to column a
288 Adjusting the screen resolution
289 Calculate course averages
290 Output from the printer as many as the number in the cell
291 Write to the cell delete the range of data to be deleted (deletes from sheet / page1 and sheet / page2 on sheet / page1 to a2b2)
292 Select the sheet / page to the left and right of the active sheet / page
293 Closing userform with esc
294 Refresh all pivot tables: a super fast method to refresh all pivot tables. Just run this code and all your pivot tables in your workbook will be refreshed in a single pull.
295 Fetch the value of a cell on that sheet / page without opening the sheet / page
296 Include a workbook in an e-mail: after running this macro, it will open your default mail client and the attached active workbook as an attachment.
297 Do you want round userform
298 Added 7 lines between line 1 and line 2
299 Currency format
300 Enable data entry & nbsp; form: excel has a default data entry form that you can use for data entry. And you can use this code to activate this user form.
301 Userforma adds a minimization and maximize button
302 Generate random number 2
303 Adjust or change column width
304 Counts how many formulas exist on the sheet / page
305 Cell copy
306 Checkbox printing
307 If more than 2 characters are written in textbox, the other textbox will send a message.
308 Type the date of the file and calculate how many days have passed
309 You specify the row and column width
310 Send mail with excel
311 Date collection in textbox
312 Select full ones (row variable column fixed)
313 Collection with textboxes
314 Finds the last space word = pir (a3)
315 Define format for all textboxes
316 Watermark printing (faded font on sheet / page background)
317 Msgbox when exiting textbox
318 Window vertical splitting 2
319 Learning listbox index number
320 Show / hide custom toolbars & remove / restore excels local toolbars
321 Give background color by number on active sheet / page2
322 A cell that we want to be active when pressed
323 Looking at the date i wrote on the first line, opening the working days of that month down to the other cells with a single movement.
324 Workbook encryption
325 Run the same macro on other sheets
326 The requested sheet / page comes in the opening
327 Shutdown and restart the computer
328 Password
329 References control
330 Row and column width
331 Adds months as a sheet / page and writes the days of the month and goes to the active month and day
332 Button on-off
333 Random
334 Remove negative marks: this code checks all cells in the selection and makes all negative numbers positive. Select a range and run this code.
335 Tab order dialog window
336 Selects individual bottom row from active row
337 The find window
338 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.
339 Write value to another cell
340 Importing data from a text file (all data one by one)
341 Determine whether any range is assigned as a range name
342 After data entry into cells
343 Find the second or third (or appropriate order) word in a sentence
344 Separates the same ones in column a as sheet / page space
345 Folder deletion
346 Deleting selected row without deleting formulas in other columns
347 Is the selected part within a certain region?
348 Column transfer order by deleting spaces ci
349 Adding the numbers entered in the combobox to the other combobox
350 Learning the name of the book
351 The title of your userform is +
352 It is forbidden to enter double records in column a1 (if you enter the cell manually, it deletes)
353 Omission
354 Capture the division error to zero
355 Find / detect the first empty cell
356 Update pivot tables in all open excel files
357 Merge window
358 Opening macro (requested sheet / page)
359 Penny in the textbox 2
360 Show blank lines on sheet / page
361 Dialog window "series axes"
362 Paste graphic into an image: this code will help you convert your graphic into an image. Just select your chart and run this code.
363 File upload by file path
364 Import data from text file write to column a
365 No userform x
366 Hide other toolbars except the file menu
367 The closure of your book depends on the value of a cell
368 Is there one or more fields in the selected field?
369 Moves to the blank row below the last full row in the column
370 Target search window
371 Userform s title moves
372 Capitalize the first letter of the words written in the textbox
373 Sum of digit values
374 Make full screen and hide bar
375 Informs which button is pressed (commandbutton)
376 Get total in listbox
377 Reverse text: all you have to do is enterrvrse" in a cell and look at the cell that contains the text you want to reverse.
378 Formula converter
379 Zoom in and out when you select the active cell (cell c2)
380 Shows sheet / page2 hides (2 clicks in sequence)
381 Change sheet / page names wholesale
382 Exiting the workbook at x pressure in userform
383 Automatically opening the column at the desired width when you click on the cell
384 Web options browsers dialog window
385 Listbox a lists the list of as in b in the textbox delete with commandbutton
386 Message box caption
387 Highlight unique values: these codes will highlight all cells with a unique value in the selection.
388 Learning clock with message
389 Find with inputbox
390 Sorts the sequential numbers in the selected cells in reverse order
391 Cut copy paste cancel
392 Can registration be prevented?
393 Makes 3 cells thick from bottom to bottom on active sheet / page
394 Mail editor mailer dialog window
395 Read the number in dollars = dollartext (a1)
396 Listbox1. Rowsource problem
397 Numbering
398 Picture appears when you enter a value in the cell
399 Who opened the file
400 Mail logon dialog window
401 Delete a file on the computer
402 Making demo program
403 T. C. Getting the current exchange rates of the central bank
404 In textbox7, the data should be written to the right.
405 Unprotect worksheet: you can use this macro code if you want to unprotect your worksheet. All you need to do is tell us about the password you used to protect your worksheet.
406 Find macro
407 Macro should not be opened after the date i want
408 Double-clicking the address in the listbox2
409 Apply style dialog window
410 Insert words into cells
411 Filter by criterion in a1 (filter operation)
412 Run the macro in the module from the active sheet / page
413 View system printers
414 Clearing the clipboard after a copy command
415 Prints selected areas on a sheet of paper
416 Asking for a password to display the hidden sheet / page
417 Click on the button to get data from the combobox
418 3 times password right
419 Comboboxta
420 Collects a1 values ​​of all sheet / pages and reports
421 Delete all modules in an excel file at the same time
422 Assign a macro to the f9 key
423 Thousands separator in textbox 1
424 Timed macro ontime?
425 Multisheet / page navigation
426 Seriesx dialog window
427  drive type show 5
428 The letter (i) written to a1 is 90 degrees oblique
429 Find function
430 Click on one of the abcd letters on the sheet / page to print the desired
431 Cancel sheet / page deletion (ing. Excel ver. )
432 Protects all sheet / pages and locks
433 Audible clock
434 Calls sheet / page protection menus
435 Sorts data and finds name
436 Dialog window
437 Change other column depending on value.
438 Checks to see if the file is open
439 Replicates the formula downward in cell e2
440 Open excel file on network
441 Add and delete menus
442 Prints cells with data
443 Determining whether the cell contains a numeric value
444 Generates random numbers smaller than 49
445 Opentext dialog window
446 Add toolbars to combo box and select from there
447 Converts the first letters of a1-a5 to uppercase
448 Warning messages 2
449 Save as with name in a1
450 Forcing data into textboxes
451 Calculation options window
452 Dialog window "save new object"
453 Collection in textboxes
454 Saving excel file
455 Add comment to cell (with message box)
456 Comboboxta sorting
457 Double-line message box 3
458 Link to a1 and open outloook with mail in a1
459 Sheet / page link update
460 Enter letters or numbers only
461 Open excel multiuser
462 Save to a blank line of the sheet / page that is closed
463 Omit gaps in textbox
464 Array shape dialog window
465 Shift selected cells down.
466 Unhide dialog window
467 A copy of a sheet / page (specify its name)
468 Add title dialog window
469 Cancellation of file layout menus and new menu
470 English and turkish menus
471 Add image dialog window
472 Create a new sheet / page and name it.
473 Note on sheet / page
474 Deletes duplicate records (duplicate records)
475 Wiping
476 Listbox filtering
477 Userform 3 hides the close button on the top right of userform
478 Registration by date and sequence number
479 Desktop icon creation
480 Close button in userform
481 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.
482 Delete our file
483 Get data from combobox to listbox
484 Find or find the number on the sheet / page
485 Transition from multisheet / page to sheet / page
486 Penny calculation
487 Combine textboxes in a single textbox
488 Finds data
489 It does not delete even if a row is full in any column of the active row.
490 Save and close book automatically
491 Form closure
492 Click any cell in column a to give the row number
493 The name of your network connection
494 Empty cells become green
495 First letter capital others small (spelling)
496 Deleting the menu bar and creating a custom menu
497 Calculate the size of the book
498 Warning messages 1
499 Convert formulas in selected cells to value 2
500 Open my documents folder with alt + f4


aaaaa