Free Excel Macros (VBA)


Enter keywords related to the macro you are looking for.

Free Macros
NoMacro Name
1 Prevent deleting formulas on the sheet / page (delete key cancel)
2 Display of the sheet / page with the screen resolution set to 800x600
3 Set the format of the text box
4 Ytl in textbox
5 Shut down the computer completely using a macro
6 Finding the type of active cell
7 Goes to the last active cell
8 Excel outlook
9 Closure of active and inactive books
10 Restoring old formulas (renewal of formulas)
11 Print file name path and worksheet name with functions
12 Turkish alphabetical sorting also sorts hidden sheet / pages
13 Undo --- undo
14 Write the latest data in column a to b1
15 Search color
16 Edit color dialog window
17 Beep sound decal
18 Prints the name of the workbook and active sheet in the active cell
19 Dialog window "pivot table wizard"
20 List all character numbers with macro
21 Clears the contents of all textboxes
22 File cd rom checks your name does not keep closing
23 To turn capslock on
24 Selects filled columns c
25 Seconds message in statusbar
26 Office assistant print hello
27 Opening macro (message in active window. )
28 Save each sheet / page separately as a book
29 Double-click the address in the listbox and close the form2
30 Translate the number / number into english (in dollars and cents)
31 Add-ons window
32 Moves to the selected cell
33 Opening rows with macro
34 Merge window
35 Delete window
36 After data entry into cells
37 Errorbarx dialog window
38 Delete txt file
39 Cell selects specific active line
40 Importing filled ones from cell into listbox
41 Prevents form drag
42 Text in the text box
43 Create a new sheet / page and name it.
44 Network printer also prints
45 Change text dialog window
46 Extract dialog window
47 Open a new worksheet with a name entered in textbox1
48 To determine the number just before the first font
49 Add a cell value to a comment
50 Random selection starting from different cells
51 Use the new line (enter) character when writing notes in a macro
52 Hiding columns
53 Automatic upper case input in textbox
54 Filtering by color in the cell
55 Inserts sheet / pages as hyperlinks
56 Print value in a1 to txt file
57 It does not delete even if a row is full in any column of the active row.
58 Tells the line number of the most recently entered data (in column a)
59 Sheet / page encryption and opening
60 If you enter data between a1-a20
61 Give the column number to find the column
62 Enter letters or numbers only
63 Run the macro in another book
64 Print the brand of your printer in cell a1. (api)
65 Book every opening a1 1 increases
66 Pivot field properties dialog window
67 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.
68 Detailed address column no column name row no row name
69 User-defined function
70 The closure of your book depends on the value of a cell
71 The operation of different macros in response to the data entered in the cell in column 5
72 Output as many as the number in the cell
73 Print-out a5 paper without preview
74 Copy cells as images
75 Lock userform 3
76 Exiting excel file without saving closing without saving
77 Double-click any cell in column b to increase 1
78 Wmi information
79 Active or passive command button according to the conditions
80 Sequential sheet / page inserts
81 Save as
82 Creating a book with cell name c1
83 Closing userform with esc
84 Which command activates a cell
85 Capital letter 2 on sheet / page
86 Array shape dialog window
87 Change window
88 Add 0 zeros to the beginning of the digit in the textbox
89 Give background color by number on active sheet / page
90 Vlookup formula or function with 3 (three) parameters
91 Display the formula in the cell / shows the english format of the formula in the cell
92 Is there an excel file or not?
93 Find criteria matching in column c (from c2) and delete all rows (criterion combobox)
94 Cell
95 Book opening (single file)
96 Hides rows whose totals are equal to zero
97 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. "
98 Highlight annotated cells: use this macro to highlight all cells that have comments.
99 Line up to last line
100 Deletes the same ones in column b and leaves 1
101 More or less right left
102 Modify formulas inside cells using macros
103 Scale dialog window
104 Let me give a warning if i pass empty
105 Use of combobox
106 Errorbary dialog window
107 Opening all excel files with 85%
108 Show file system
109 Detailed report on harddisk
110 A1: a10 makes cells thicker than 10 between
111 Close button in userform
112 Book title naming (caption)
113 Specify file path and extension list in detail
114 Msgbox according to condition
115 Learn your screen resolution
116 Cursor skips empty cell
117 Send or bulk mail with outlook
118 Macros box and macros appear
119 Pulling up the dollies by wiping the empty ones
120 Adds 1 row to given cells from a1
121 One-click check in column d e
122 Run individual macros based on active sheet / page
123 Prints the name of the active workbook in the active cell
124 To preview the desired sheet / page name in the book
125 Combobox can not get data a...
126 Warn if the format is incorrect.
127 Delete comment (comment) in cell
128 Userform pops up when you click between cells
129 Method 2 to log off the computer
130 To run a macro in another book over a network
131 A1 when writing the date and time
132 Let enter come back 2
133 Add dialog window
134 Sheet / page protection automatic filter open
135 Remove sheet / page protection
136 Column and the value to be searched are written into the macro
137 Open a txt file on a sheet / page and import its contents the name of a txt file is the sheet / page name
138 Delete rows that match a specific criterion
139 Temporary folders
140 Close all forms showmodal false ones 1
141 Gallery pie dialog window
142 Dial up
143 Double click to go to the sheet / page i want
144 Displaying the sum of any column values ​​in the listbox in the textbox
145 Hiding
146 Sorts data and finds name
147 Dialog window "series axes"
148 Determine whether any range is assigned as a range name
149 Collection with textboxes
150 Select lines
151 Highlight negative numbers: select a range of cells and run this code. It checks each cell of the range and highlights all the cells that you have a negative number.
152 Apply style dialog window
153 Enable a1 reference style: this macro code will help you enable the a1 reference style without using the excel options.
154 Animated gifs userformda
155 Goes to the first empty cell in the row
156 Cell_formify_subscribe (mock)
157 Saving the active workbook
158 Hides empty rows in column a
159 Function calculating workdays
160 Sheet / page ranking
161 Separates the word a1 in a sound and silent manner
162 Routing note dialog window
163  show free space
164 Wmi video card
165 Error check dialog window
166 Select cell identification
167 Pivot tables data iteration
168 I have numbers in label1 and label2. I want to average the numbers in label1 and label2 in label3
169 Go to the selected sheet / page in the combobox
170 Dialog window "set tuple editor in rows"
171 Blinking effect
172 Delete a blank line
173 Retrieve data from closed files
174 Write month names by creating sheet / page names
175 Wiping time scroll
176 Canceling the enter key
177 Message box double row 3
178 Module hiding
179 Show sheet / page tabs in cell
180 Importing data from a listbox column
181 Increase active cell 30
182 Use target seek: target seek can be super to solve complex problems. Learn more about destination search here before using this code.
183 Data between cells a1: af12 flashes
184 Replace characters in text with macro
185 Sheet / page names
186 Folder operations with vbs
187 Finds the last space word = pir (a3)
188 Select all cells on the sheet / page
189 Userformda calendar
190 Returns the number of rows for the selection.
191 Just enter a period or comma in the textbox
192 Deleting empty rows2
193 Pending message
194 Listing sheet / pages in the combobox and moving to the selected sheet / page
195 Hide and show half of a picture
196 Right mouse menu on sheet / page
197 Clock date functions
198 Auto-run macro you want at boot
199 Color by number on active sheet / page
200 Fixed to be assigned to commobox
201 Do not send messages when deleting sheet / pages
202 Send active sheet / page by email
203 Deleting selected row without deleting formulas in other columns
204 Goes to the top of the sheet / page
205 Search for a text / text in all open excel files
206 Gather sheets of a sheette
207 Prints the active sheet / page
208 Change object property at once
209 If you choose 2nd place in combobox, eat k2
210 Minimizing the active window at boot
211 Macro that locates the searched word and clears that line
212 Edit array dialog window
213 Sheet / page showing at opening and not appearing at closing
214 Make excel userform exe
215 Dialog window "addin to make vba"
216 A code that gives the full directory name
217 Remove the sheet / page protection password
218 C10 if a1 is 0: hide if c20 show 1
219 Comboboxa manual data entry prohibited 2
220 Manage relationships dialog window
221 Constant values ​​to be assigned to combobox
222 Is there one or more fields in the selected field?
223 Adds cells with red background color between cells a1: d20
224 Print button do you want to preview the sheet / page to be printed
225 Go to cell
226 Trading with a single userform
227 Convert selected cells to uppercase or lowercase with one click
228 Book auto-save
229 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.
230 Guide lines dialog window
231 Column hiding conditional
232 On sheet / page b5: g22
233 Converting to suitcase: and this code converts the selected text into the correct word that fills the first letter of capital with lowercase letters.
234 Currency format-currency in textbox
235 Create publisher dialog window
236 Assigns date to the next line when data is entered in certain cells on the sheet / page
237 Show sheet / page2
238 Type b1e as the number changes in the same cell
239 Display names in a1 in the listbox
240 Learn the name of the active printer
241 Importing data from a sheet / page in the listbox
242 Same sheet / page warning
243 Listing sheet / pages in a book in the listbox
244 Learning harddiskin free space etc..
245 Sheet / page copy (copies the sheet / page with index name 2 c6 by deleting the buttons)
246 Print by increasing the value in the cell one by one
247 Add username and password
248 Link collection
249 Zoom in / out and make selected cells visible
250 You can delete all codes on sheet / page1
251 Userform full screen
252 Preview macro
253 Selects active column
254 Wmi motherboard
255 Highlight the maximum value in range: controls all selected cells and is highlighted by the maximum value of the cell.
256 Dialog window "data verification"
257 Hides empty rows in column c
258 Random number generation
259 Cells detailed information (address)
260 Check whether the message is a date format
261 Convert double and single lines into different colors and designs (one line is bold and the other line is normal)
262 Resize the comment of the cell
263 Copy the formula in the cell by the number of rows that have changed
264 Get the name of the sheet / page a1
265 Leads to the last row without data
266 Thousands separator in textbox 2
267 Add time as menu (most reliable)
268 Number message in status bar
269 Button on-off
270 Time difference calculation
271 Move workbook dialog window
272 Codes collecting numbers in active cell
273 Open a htm file
274 Run macro at desired hour and minute 2
275  show driver ready
276 I want to delete duplicates (may delete rows)
277 Active cell color
278 Paste cells as values ​​
279 Delete text file 2
280 Remove gaps
281 Data transfer...
282 Select column to add red colored figures to a1
283 Show hidden description (select cell)
284 Click on labele
285 Dialog window "vba procedure description"
286 If formula 7 and more
287 See the old value in the modified cell
288 Add image dialog window
289 Selects the line containing the active cell
290 Putting / removing protection on multiple sheet / pages
291 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.
292 Still inputbox
293 Calculation options window
294 Double-click on a sheet / page
295 Finding the largest number in cells / which is the largest number in a field
296 The data that i specify as a folder filename
297 Active cell printing
298 Pushbutton pictures
299 Combination dialog window
300 Add title dialog window
301 What week of the year (by formula)
302 Set background image dialog window
303 Makes workarea1 0
304 Collapse userform
305 Automatically save file name when saving different
306 Hide and show from 10th line
307 Right mouse menu
308 Timed userform
309 Generates random numbers smaller than 49
310 Move to the next sheet / page with one click in the cell on the sheet / page
311 Auto-sizing userform
312 Count characters in cell
313 Find alt + enter and number format / empty cell in textbox
314 Remove the formula bar
315 File search
316 Shortening of sentences / creating short sentences using the first letters of the words in a sentence
317 Formulated cell colored
318 User-defined note function
319 Warns if textbox is less than 10
320 Off without saving
321 If there is data on the selected cell, it selects them. Selects the first cell after the first empty cell.
322 Print side by side with loop
323 Root file show
324 Finding the print area
325 Receive a message after each data entry
326 Remove standard toolbars in excel
327 Userform exit with cancellation message
328 Hide d1 if cell a1 is full show if empty
329 If a1 is 0, show between 10 and 20 rows if not
330 Right mouse forbidden on active sheet / page
331 Time in cell (by defining name to cell)
332 Delete data from listbox
333 Prints selected areas on a sheet of paper
334 Row and column width
335 Hyperlinks to sheet / pages from the active cell
336 Macros that determine and cancel your workspace on your worksheet
337 Automatic date format in cell
338 It is forbidden to enter double records in column a1 (if you enter the cell manually, it deletes)
339 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.
340 The data you receive in combobox is changed to big week
341 Combine textboxes in a single textbox
342 Transfer sheet / page names to combobox
343 Limit the number of characters to be entered in a text box on any form
344 Add workbook dialog window
345 Button scrolling data
346 The value passed from the listbox to the textbox is output in the same format
347 Adding additem to the listbox with a "for" loop
348 Flip the image on sheet / page 180 degrees
349 Thousands separator in textbox 1
350 Collects a1 values ​​of all sheet / pages and reports
351 List fonts with samples
352 Listing subprograms in a workbook
353 Remove date from date and time: returns only time from a date and time value only.
354 Select by intersecting full row and column (perfect)
355 Format cell / fonts window
356 Question and answer in inputbox
357 Comboboxta
358 Replicates the formula downward in cell e2
359 Hides all sheet / pages and shows the sheet / page you want and vice versa
360 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.
361 Reporting text in textbox as message
362 Nam definitions given to cells
363 Sheet / page scrolling
364 Translating all rows of selected cells.
365 Show all row columns
366 Vocal reading
367 Distinguish two adjacent columns until the end of the column
368 Deletes duplicates in column b
369 Book total how many times which date and time opened
370 A worksheet and create a hyperlink from a folder
371 Exit procedure
372 Text color in texbox
373 Recording and running the macro at boot
374 Reading textbox aloud
375 Right mouse on active sheet / page menu
376 Draw borders across cells2
377 Dialog window "set manager"
378 Save book close window select
379 Keeping a record in memory
380 Copy and paste the selected region / cell set
381 Import the active cell into listbox and textbox (using spinbutton)
382 Commandbutton
383 Printout at desired time
384 Add sheet / page automatically in cell a1
385 Rounding formula in cells 2
386 Saves according to the sheet / pages in column b
387 Is the selected part within a certain region?
388 Hide or show pivot table fields
389 Saving output
390 Api to create shortcut to my excel file on desktop
391 Document inspector dialog window
392 Just delete values ​​from the cell
393 Determining the name of the sheet / page and file containing the active cell
394 Printing selected data with option button
395 Do not delete formulas on the sheet / page (allow others to be deleted)
396 Adding values ​​of cells of a particular color, for example, what is the sum of cells of yellow color?
397 Recording on the same
398 Record on the same ones
399 A1 1 is b1 march
400 Click on any cell to run the macro
401 The location of the userform.
402 Code that finds the number of sheet / pages 1
403 Finds filled cells in column a and encapsulates print area
404 Assigns a value to the desired cell on the specified sheet of an excel workbook that is open
405 Open file again
406 Add sheet / pages as menus
407 Hide empty columns
408 Converts text to uppercase & lowercase
409 Delete all empty rows in column
410 Perfect mp3 playback
411 Show all hidden sheet / pages
412 Cd on and off
413 Sheet / pages with toolbars and menus
414 Chart type dialog window
415 Calculate the size of the book
416 Copying data from one sheet / page to other sheet / pages
417 Hides above rows with data
418 Date collection in textbox
419 Deletes the name of the cell
420 Show progress in status bar: you can use this macro to show the progress of a macro code in the status bar. This code will add up to 5000 serial numbers to your sheet / page and will progress along with the status bar.
421 Horizontal and vertical shifting
422 For normal display
423 Deletes data
424 In the cell next to the month (according to the data in the abc column)
425 B2c2d2 takes the date in a2 as day month month year
426 Copying codes
427 Encrypt all book and sheet / pages 2
428 Go to sheet / page3 in double-click
429 Zoom in / out or reduce the active sheet / page to a certain size
430 Button movement
431 Block save as
432 Sheet / page count
433 Learn the address of the active cell by message
434 If data is present in cells a1: a5, b6: b10c1: c5 d4: d10 on all sheet / pages
435 Write to the bottom cell if the number of letters is more than 100 1
436 Desktop icon creation
437 Zoom dialog window
438 Active workbook in email: use this macro code to quickly send your active workbook by email. & nbsp; you can change the subject email and body text in the code. If you want to send this mail directly, use. Send" instead of. Display. "
439 Decimal total
440 Opening a web sheet / page
441 Warning message 4 x shaped warning window
442 Sheet / page1 to be full screen
443 Rows and columns scroll
444 Learn the latest registration date at opening
445 Sound when you enter letters in textbox
446 Conditional deletion with macro
447 Height of the next line after every 5 lines 5
448 Make the workbook full-screen
449 First full cell from right to left
450 New webquery dialog window
451 Macros that determine and cancel your workspace on your sheet / page
452 Hide file menu bar
453 Transferring data written to textbox to cell
454 Let fcommandbutton move.
455 Adding the numbers entered in the combobox to the other combobox
456 You specify the row and column width
457 Paste a cell community / region into another region
458 Floppy disk backup
459 Saving from sheet / page 1 to 2 by filling in the blanks
460 Style window
461 Specify partition, list how many files you have
462 Multisheet / pagee click macro work
463 All windows minimized
464 Pivot calculated area dialog window
465 Gives the address and type of formula if the active cell contains a formula
466 Gallery 3d bar dialog window
467 Dialog window "coding web options"
468 Get the alert you want wherever you want
469 Selecting tab and textbox content 2
470 Print sheet / page names to column a of the sheet / page
471 Force
472 Printing the value of the buttons to the lab
473 Term userform 2
474 Yes and no macro execution
475 Printer window
476 New sheet / page with name in cell a1
477 Easy menu with right mouse
478 Translate text to cell event from userform
479 Create list dialog window
480 Fetch last row and column number
481 Search for a file and confirm it
482 Data scrolls
483 Userform 6) deactivate the close button at the beginning of the userform
484 Make all names visible in the name manager
485 Add date and time in two clicks
486 Convert formula to value
487 A byi compare the same ones cye different ones dye
488 How many empty lines are added between active and full cells
489 Separates numbers from letters and numbers in a column
490 Requested sheet / page at opening
491 Function run code2
492 If checkbox is approved, let a1 write 100 1
493 Inputbox filtering and deleting filtered
494 New workbook dialog window
495 Macros to work on the desired sheet / page
496 Automatically filter excel sheet via userform
497 Dyes empty cells between cells a1: a10
498 Userform 3 hides the close button on the top right of userform
499 Listing sheet / page names (tab name)
500 Show changing cells


aaaaa