Free Excel Macros (VBA)

Enter keywords related to the macro you are looking for.

Free Macros
NoMacro Name
1 Data transfer...
2 Transition from multisheet / page to sheet / page
3 Rename the additem in the listbox
4 Delete an image on a sheet / page
5 Ytl in textbox
6 Import only full cells into listbox
7 List all character numbers with macro
8 Sheet / page1 to be full screen
9 Decimal control
10 Write numbers to a1: a5 and warns c1 if their total is less than 100
11 Leads to the last row without data
12 Mail editor mailer dialog window
13 A1: a10 compares c1: c10 and gives warning if the entered numbers are different
14 Create and write text file 4
15 Find and show on sheet / page
16 Inserts date between e1: e10 when entering data between a1: c10
17 Message box caption
18 Gallery 3d area dialog window
19 Userformda clock
20 Coloring in textbox
21 Assigning random numbers as a value to cells in the selected region
22 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.
23 Displaying numbers in text
24 To call a macro from within a macro 2
25 Find file dialog window
26 The closure of your book depends on the value of a cell
27 Display the "save as" box and save as (dialog window)
28 Update connection dialog window
29 Im opening an excel file with vb code, but running the macro in this excel file
30 Opening all excel files with 85%
31 Adding serial numbers: this macro code will help you automatically add serial numbers to your excel sheet. After you run this macro, it will display an input box where you must enter the maximum number for serial numbers, and then add a number to the column in a column.
32 Format move dialog window
33 Create your own extensions and functions in excel
34 Resolution learning
35 Opening a calendar in a cell
36 Moves to the first empty cell in the column
37 Userform 1 userform title
38 Show excel file in full screen or exit full screen
39 Convert selected cells to uppercase or lowercase with one click
40 Copying data from one sheet / page to other sheet / pages
41 There are 3 text boxes on the userform and we want the value of textbox1 to be 2 and 3
42 Go directly to the sheet / page
43 Last recorded cell
44 List the sheet / page by message you just write the number goes to that sheet / page
45 Dated copy
46 Receive a message when saving a book
47 Data changes
48 Delete our file
49 Number message in status bar
50 Gallery 3d line dialog window
51 If cell c1 is empty empty cell c4 if not empty value in cell c1
52 Entering only letters in the textbox
53 Find-change-delete-save macro
54 Nobody else save the file
55 Select cells to delete 2 kinds of bullet (3 clicks in turn)
56 Copy multiple columns at once
57 Determining the type of expression or type of text in the selected cell (text or number)
58 Change sheet / page names wholesale
59 View3d dialog window
60 Active cell color
61 Extract dialog window
62 Web options browsers dialog window
63 Highlight alternative rows in selection: you can make your data easily readable by highlighting alternative rows. And you can use the following vba code for this. & nbsp; highlights each alternative row in the selected range.
64 Deleting sheet / page names other than x and y
65 Adds a new sheet / page named month and year, together with the data a1: a5
66 Macro that locates the searched word and clears that line
67 Deleting selected row in listbox
68 Auto fix window
69 Show sheet / page2
70 Im opening an excel file with vb code, but running the macro in this excel file2
71 Button movement
72 Zoom in and out when you select the active cell (cell c2)
73 I have numbers in label1 and label2. I want to average the numbers in label1 and label2 in label3
74 Deletes empty rows in column a and pulls up
75 Sheet / page names in alphabetical order 2
76 Select the full area on the sheet / page
77 Listing sheet / page names (tab name)
78 Pasting to the end of the list
79 Write the number you want to be colored on the sheet / page in msgbox
80 Add menu to file edit menu
81 Sheet / page scrolling
82 Add find commandbotton in userform
83 Picture insertion window
84 Copy textbox content
85 Macro should not be opened after the date i want
86 Restoring old formulas (renewal of formulas)
87 Select empty cells
88 List columns in rows
89 Opening a word document
90 Floppy labeling
91 Cancel the filter
92 Style dialog window
93 Select the previously processed cell
94 Dialog window "list box properties"
95 Day date time in message box
96 Auto-sizing userform
97 Calculate course averages
98 First letter of words in cell
99 If you choose 2nd place in combobox, eat k2
100 Opening a web sheet / page
101 Return to form when preview closes from userform
102 Data series dialog window
103 Generates random numbers smaller than 49
104 Register with textboxes
105 To the code section of the userform
106 Calculation as soon as you type textbox
107 Warning messages 2
108 Dialog window "scenario cells"
109 A1 when writing the date and time
110 Data that you type into the texbox in your userform is simultaneously printed to cell a2 in your excel worksheet
111 Filtered transfer
112 Wmi bios
113 Hide the mouse cursor 2
114 Delete a set of rows
115 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.
116 Calculator invocation
117 Add hyperlink dialog window
118 Hide the desired column
119 Whether the sheet / page has protection
120 Does excel drawing?
121 Find the first spaces and letter groups from right and left
122 B3e enter data insert web sheet / page as sheet / page
123 Deleting all names given using name manager
124 Learning screen resolution
125 Writes b1 date to b2
126 Open dialog window
127 Selecting empty lines by inputbox
128 Excel crack
129 Sheet / page protected if b2 is blank
130 Key in the inbox
131 Sheet / page1 a1b1c1 is full and column b is hidden and copy c1 i to sheet / page2b on a1b1
132 Under-registration
133 Give the column number to find the column
134 Calls sheet / page protection menus
135 Print hidden sheet / page
136 Row sort up to whole column
137 Calls the notebook
138 Adding two lines and removing total
139 Remove sheet / page protection
140 Adds a blank description to the selected cell
141 Open count unsaved workbooks: if you have 5-10 open workbooks, you can use this code to get the number of workbooks that have not yet been saved.
142 Sorts the numbers in column a (even if one of the tweens is deleted) 2
143 Object assignment dialog window
144 Which cell you want to go to by scrolling
145 Replace characters in text with macro
146 Select characters in textbox with arrow
147 Opening internet explorer in excel
148 Open excel file on network
149 Informs which button is pressed (commandbutton)
150 Hiding tools menu
151 Fills the line spacing on the sheet / page
152 Sound when you enter letters in textbox
153 Textbox activation
154 Go to sheet / page3 in double-click
155 Dialog window ekle add options lists dial
156 Collection in textboxes
157 Turning add-ons using macro on or off
158 Floppy disk backup
159 No warning when deleting sheet / pages
160 Select by intersecting full row and column (perfect)
161 Dialog window "color palette"
162 Automatically save file name when saving different
163 Macro options dialog window
164 Copy and paste one region into another
165 Comboboxta
166 Book backup to floppy disk
167 Whether to print straining 2
168 Let macro run if the value of cell a1 is lower than the value in cell a3
169 Makes the print area a3: f15 and selects and prints the line to repeat
170 Hide empty rows
171 How to remove sheet / page protection
172 Forcing the computer to restart (method 1)
173 Open a notebook or other applications
174 Cell area interrupt selected area interrupt
175 Selects the row containing the cell in the listbox by double-clicking it and the form closes
176 If a5 = 2, do not open the userform
177 Userforma adds a minimization and maximize button
178 Receiving messages with inputbox
179 Learning user name and pc name
180 Calls the browse folder window
181 Finds filled cells in column a and encapsulates print area
182 Close the file
183 Chart wizard dialog window
184 Selects full cells and converts them to lower case
185 What row
186  drive type show 5
187 File upload by file path
188 Add alerts to pushbutton commands
189 Saving if cell a1 is empty
190 Calculator on / off
191 A shortcut to find out how many people are on the list.
192 Transferring text from textbox to cell
193 Navigation button with multisheet / page
194 Sheet / page encryption and opening
195 Processes the opening date and time of the file in txt (bottom to bottom)
196 Automatic collection process
197 A1: a10 makes 21 cells out of 10 ones
198 Delete all modules in an excel file at the same time
199 Hyperlinks to sheet / pages from the active cell
200 Customization of toolbars remains in the file menu
201 Formula replication
202 If the sheet / page is blank, inserts the date in the footer and prints if not
203 If cell a1 is greater than zero, let the macro run.
204 Macro example of continuous flash
205 Blink if a1 = 1 and stop if 0
206 Deciphering the encrypted text
207 Hide the start bar
208 Zoom in / out and make selected cells visible
209 Divides the text in the active cell into letters (divided by 3 characters into columns)
210 Learning harddiskin free space etc..
211 Closing the users book
212 Closes the comment form
213 Highlight the top 10 values: select a range and run this macro and highlight the top 10 values ​​with green.
214 New document opening window
215 Search combobox change
216 Userform exit with cancellation message
217 Auto-fit data into cell
218 Bounces from active cell to a sub cell
219 Make visible if textbox box is invisible
220 Open auto filter (filter)
221 Listbox or combobox header format
222 Create a sequential and cell-wide textbox
223 Saving the active workbook
224 Show changing cells
225 Open and close notebook
226 Root file show
227 Auto macro recording
228 Determining that a row or column is empty
229 Opening dataform
230 Non-movable userform
231 Return userforma when you close print preview
233 If the number of letters is more than 100 write to the bottom cell 2
234 Word merge with numbers on active sheet / page
235 Add a comment to a cell
236 Selects everything including row column names cells
237 Conditionally delete rows based on value in
238 Nam definitions given to cells
239 Select tab and textbox content
240 Make the visual basic project access trust checkbox true.
241 Change password with save as
242 Pdf preview
243 Textbox date example
244 How do i print the 2nd column of listbox?
245 Digitization macro
246 Checkbox
247 Exceli closing process
248 Give a password to the cell
249 Sheet / pages protection
250 Separates the text in the active cell into letters (columns)
251 New book opens
252 Detection of a region named with the name manager / is there such a name given anywhere?
253 Link collection
254 Print value in a1 to txt file
255 Delete a link on a sheet / page
256 Writes the name of the sheet / page and the sheet / page number of the footer.
257 Date printing on textbox
258 Message box double row 2
259 Dialog window "addin to make vba"
260 Makes all selected cells 0
261 Go to cell
262 Writing code
263 Macros box and macros appear
264 Returns the number of columns for the selection.
265 Protect workbook dialog window
266 Text to speech: just select a range and run this code excel will speak all the text in that range from the language of the cell.
267 Excel version finder
268 To play a wav file in your current directory
269 Opening macro (message in active window. )
270 Formula
271 Worde writes a report with or without internet connection
272 Desktop icon creation
273 Delete empty rows in column one by one
274 Whichever cell is full (a2: e2) write it to the other cell (a5)
275 Another command instead of "wait"
276 View system printers
277 Conditional numbering in a1
278 Cells a1 to a3000 make red if there is any data and send the line completely to sheet / page 3
279 Formulated cell deletion
280 Mouse cursor hourglass
281 Save a dated and undated book with a cell name
282 Table dialog window
283 Take a picture (printscreen)
284 Save workbook
285 Prints selected areas on a sheet of paper
286 Open the sheet / page with the name in a1
287 Adding additem to the listbox with a "for" loop
288 Make sheet / page names in excel file invisible
289 If you enter data between a1-a20
290 Printing all data in listbox1 to excel
291 Code that finds the number of sheet / pages 1
292 Protect all worksheets now: this is a code for you if you want to protect all your worksheets at once. & nbsp; when you run this macro, you will find an input box to enter a password. After entering your password, click all. And be careful with caps.
293 Encrypted entry to workbook
294 Size dialog window
295 Close all forms showmodal false ones 2
296 Customize toolbar dialog window
297 Fetch the value of a cell on that sheet / page without opening the sheet / page
298 Main chart type dialog window
299 Xls files in directory c
300 Create a new sheet / page for workdays
301 Welcome message: you can use auto_openi to perform the task of opening a file. All you need to do is call your macroauto_open. "
302 Book gets backup dated this day when opening
303 Click any cell in column a to give the row number
304 Gallery bar dialog window
305 Insert date as left header when sheet / page is active
306 Just enter a period or comma in the textbox
307 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.
308 Show all hidden sheet / pages
309 Opening a txt file
310 Finds searches in abc column
311 Hide-show right-click menu in excel
312 Name of active sheet / page in cell a1
313 Sort data by name order
314 The location of the userform.
315 Run macro at desired hour and minute
316 Font values ​​of the values ​​in the cell thickness
317 Workbook encryption
318 Identify and select only empty cells in the selected area
319 Prevent deleting formulas on the sheet / page (delete key cancel)
320 Macro2 when cell is empty macro2 when full
321 The find window
322 Remove all links in selected cells
323 Auto-play the desired macro at boot &
324 Retrieve data from closed files
325 Paste a cell community / region into another region
326 Property areas dialog window
327 Is the size of a file in bytes?
328 Userform at bottom right
329 Scrolling
330 Coloring rows and columns
331 Sheet / page names
332 Delete from listbox with double click
333 Edit array dialog window
334 Send mail with excel
335 Save as action
336 Add buttons to an existing menu bar
337 Change the title of a book
338 Macro to hide the sheet we will write to open the macro to ask him to know the password
339 Create subtotal dialog window
340 Is there a zone error to zero
341 Timed userform
342 History operations 2
343 Special gluing options / format gluing design gluing formula gluing column width gluing transpose gluing
344 Create a content table: suppose you have over 100 worksheets in your workbook. And now it is hard to navigate. Do not worry that this macro code will save everything. When you run this code, you will create a new worksheet and create a & nbsp; will create a directory.
345 Select value in combobox
346 Perfect mp3 playback
347 Define format for all textboxes
348 Automatically save filename when saving 2
349 Moves to the blank row below the last full row in the column
350 Code that finds the number of sheet / pages 2
351 Seriesx dialog window
352 Indisin vba macro
353 Returns the number of non-empty cells in selections.
354 Write e1 cell and e15 cells total a1 e
355 Subtotal with auto filter
356 The data you receive in combobox is changed to big week
357 Add template title: first of all you need to select your graphic and run this code. You will receive an input box to enter the graphic title.
358 On sheet / page b5: g22
359 Hide and show the file edit menu
360 Output from the printer as many as the number in the cell
361 Msgbox in - day - date - time show
362 Protects your worksheet, but auto-filters work
363 Listbox features
364 Separates the same ones in column a as sheet / page space2
365 Do not delete formulas on the sheet / page (allow others to be deleted)
366 Hide sheet / page
367 Macro for seeing vba codes
368 Gallery 3d column dialog window
369 A1 = 1 c1 = 3 column b be hidden. Sheet2 is a1 = 1 b1 = 3
370 Automatically opening the column at the desired width when you click on the cell
371 Creates folder with book name save each sheet / page separately
372 Delete sheet / pages other than specific sheet / pages
373 Warning when working on certain columns
374 Saves data
375 Pivot field properties dialog window
376 Mouse click calculation
377 Number of files
378 Re-register event in duplicate records
379 Index cells vba code
380 Click on any cell to run the macro
381 Selected cells are colored
382 Wav playback
383 Records detailed formatted cells on the records sheet / page
384 Click on c8: c18 to open the right mouse menu
385 Column width dialog window
386 Insert multiple rows
387 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.
388 Comboboxa writes months
389 1/1 excel in textbox 1
390 Rectangle deletion
391 Add-remove button
392 Print area
393 Colorize columns differently (each column is the same color, but each row is different color. )
394 Exiting the workbook at x pressure in userform
395 Dialog window "appsize"
396 Extracts from column a to be unique
397 If the sheet / page is full, it will preview the fills in sequence and not show if they are empty
398 Find-color (cell spaced)
399 Collection with textboxes
400 Uncheck optionbuttons
401 Indis (index) function as vba code
402 Undo cells with 0
403 Create a user-defined menu / create your own menu and assign a macro to them in the "extensions" section
404 Indirect macro
405 Print the active sheet / page
406 Show drive letter
407 Labela get value from desired sheet / page and cell
408 Adding the commandbar
409 Open the form when you click between lines 2 and 21 in column b
410 Select cell identification
411 Automatically insert other data between sequential data in excel
412 Column transfer month
413 Zooming selected cells
414 Search for a driver
415 Run macro based on value in cell
416 Double-click on the active cell to write the subtotal formula of the top rows
417 Adds todays date to the active cell
418 Show the hidden stages
419 Last used cell 2 in workbook
420 Merge window
421 Textboxes are not empty
422 Save as
423 Leaves 1 space between words
424 Message box: message boxes with ok and cancel options
425 Collapse column by data in cell
426 The value in the inbox is transferred to the key
427 A code that gives the full directory name
428 Pc shutdown codes
429 Color by number on active sheet / page
430 It is forbidden to enter double records in column a1 (if you enter the cell manually, it deletes)
431 Userform to cell
432 F8 key to macro on boot
433 Apply style dialog window
434 Auto collapse description of cells change color
435 Message or macro according to the value in the cell
436 Print the sheet / page name
437 Detecting and selecting rows with single row numbers
438 Change the value of a cell in another file
439 Save a file in different ways
440 Square root of number
441 Cells detailed information (address)
442 Selects sheet / pages, makes the same cells bold, and changes the font
443 Add date to right header
444 A macro in a merged cell
445 Enter letters or numbers only
446 Dialog window "analyze settings if pivot table is available"
447 Same sheet / page have alert 2
448 Write value to another cell
449 Select all sheet / pages 2
450 Add menu to file edit menu
451 Sheet / pages other than certain sheet / pages
452 Folder search
453 List sheet / page names 2
454 Reverse text
455 Open the desired sheet / page
456 Remove date time: you can use this code if you are spending time with the date and want to remove it.
457 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.
458 Select cell area
459 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.
460 Delete every 5 min without warning if there is data between a1: a3000
461 All letters capital spelling
462 Save worksheets as workbooks
463 Collect listbox send message
464 Add timestamp: with this code, a timestamp between 00: 00-23: 00 & nbsp; you can put
465 Names the selected cell (identifies a name)
466 Untitled userform
467 Time in cell (by defining name to cell)
468 Rows and columns set in cm
469 Row height dialog window
470 Calculation of the total number of cells selected
471 Reverse printing
472 Prints the name of the active workbook in the active cell
473 Column finds full cells and encapsulates print area
474 Add a formula to a cell
475 In the deletion of the last written sheet / page, type the following code in the exit button.
476 New document opening window
477 Write the same cell in all cells on the active sheet / page
478 Go to related sheet / page
479 Learning whether the book is open by function
480 ; a to z order / letter order by name of sheet / pages
481 Forced to enter password redirects to other sheet / page
482 If a1 is 0, show between 10 and 20 rows if not
483 Right mouse menu on sheet / page
484 Data label dialog window
485 Off without saving
486 Translating all rows of selected cells.
487 Marquee
488 Find and list them in a message
489 Message
490 Gallery line dialog window
491 Changes the name property of the sheet module named sheet1 in the workbook to mysh
492 Alignment dialog window
493 Convert from row to column
494 Reporting problem
495 Select find additional or double ->
496 View the codes of the desired macro
497 Advanced filter dialog window
498 Toolbar creation
499 In the cell next to the month (according to the data in the abc column)
500 Recall the notebook