Free Excel Macros (VBA)


Enter keywords related to the macro you are looking for.

Free Macros
NoMacro Name
1 Macro run every 5 minutes
2 In the data message box in the cell 2
3 Full screen normal screen
4 Show cell add digits after comma
5 Identify and select only empty cells in the selected area
6 Specifies in detail how many references the book contains (on new sheet / page)
7 Calculation options window
8 From the sheet / page in the order in the combobox selectors in column a
9 Determining whether said excel file is open or not
10 Automatic capitalization at input in textbox 4 (for turkish character problem)
11 Run macro at desired time
12 Move sheet / pages from one book to another book
13 Prints selected areas on a sheet of paper
14 Forced to enter password redirects to other sheet / page
15 Highlight less than values: after running this code, you will want the value for which you want to highlight all low values.
16 Select rows in column delete empty ones
17 Activate the sheet / page and enter a number in the active cell
18 Do not send messages when deleting sheet / pages
19 Formula and dated copy
20 Turkish mathematical terms
21 Create names dialog window
22 In the textbox, do not use a comma, and enter 2 points before and after the period.
23 Adding menu
24 Dialog window
25 Sparkline adding win loss dialog window
26 Find and select the remaining cell in the value between 2 selected numbers
27 Select row
28 Printing these macro codes help you automate some print tasks that will save you more time. & nbsp; print comments: use this macro to enable settings to print cell comments at the end of the sheet / page. Suppose you have 10 sheet / pages to print, and after using this code you will receive all comments on sheet / page 11.
29 Mouse click calculation
30 Conversion from formula to value
31 Log off the computer method 1
32 Customize commands window
33 Opens rows on sheet / page
34 Annotation deletion
35 Show all rows and columns: you can use this code to do this one at a time, rather than overwriting individual rows and columns.
36 Write the number in minutes and seconds
37 Transformation of formulas in cells 2
38 Adjust the screen resolution
39 Print preview dialog window
40 Print by increasing the value in the cell by 1
41 A1 will always meet in a2
42 Fully closed
43 Transformation of formulas in cells 1
44 Delete name dialog window
45 Round number 3
46 Learning listbox index number
47 Target search window
48  drive type show 5
49 If we want the value of dtpicker to be a value from the database
50 Move to another cell when you type a cell
51 Cancellation of print preview commands
52 Inputbox filtering and deleting filtered
53 Assign tool dialog window
54 Reversing timer
55 Transfer sheet / page names to combobox
56 Color active cells
57 Listing sheet / pages in the combobox and moving to the selected sheet / page
58 Makes the print area a3: f15 and selects and prints the line to repeat
59 Find formula dialog window
60 Give the macro path to the combobox tryit without userform
61 Collecting and dividing with macro (percentage)
62 Reverse printing
63 Finding the first monday after any date
64 If a5 = 2, do not open the userform
65 Deleting rows in excel
66 Watermark printing (faded font on sheet / page background)
67 Sorts the numbers in column a (even if one of the tweens is deleted)
68 Data form opening
69 Show all hidden sheet / pages
70 Gallery donut dialog window
71 Number round (mathematical operations)
72 Copying the active sheet / page
73 If there is value in the active cell it writes to a17
74 Turkish alphabetical sorting also sorts hidden sheet / pages
75 Date collection in textbox
76 Move workbook dialog window
77 If a1 is empty (if you delete it) 10
78 Penny calculation
79 Add a toolbar
80 Change object property at once
81 Navigation button with multisheet / page
82 Graphic position dialog window
83 Userform 7 prompts userform when crossed
84 Pivot field properties dialog window
85 Change the color of a cells font
86 Let calculations from column a to column g (except g) calculate other open columns by pressing the button
87 Display the formula in the cell / shows the english format of the formula in the cell
88 Learning the message with classmodule2
89 Create marquee in excel cell
90 Find how many formulas are in the selected field and select all cells containing the formula
91 Sorts data and finds name
92 Exit without saving screen
93 Capital letter 2 on sheet / page
94 Lists xls files in the specified path from the active cell
95 Save as
96 2 forms at the same time
97 Increase the value within the cell by looking at the number value or assign its formula by number value
98 Web options files dialog window
99 Add a cell value to a comment
100 The data that i specify as a folder filename
101 Is the cell visible or not?
102 Textboxa only numbers and commas
103 Leaves 1 of the same ones in column a and queues
104 Show drive serial number
105 Computer name
106 Format graph dialog window
107 About listbox
108 Book backup to floppy disk
109 Term userform 1
110 Remove sheet / page protections
111 Opening windows help
112 Delete rows
113 Whichever cell is full (a2: e2) write it to the other cell (a5)
114 Reports the last full cells in columns on the desired sheet / page in the entire book
115 Â 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.
116 Automatically sorts sheet / page names by following the order in vba
117 Reset optionbuttons in userform
118 Delete empty rows in column one by one
119 Downward autofill using a macro
120 A1: select d4 activate b2
121 Column search
122 Save as cell name a1
123 Remove one character from selection: you can use this code to remove a specific character from a selected cell. It will display an input box to enter the character you want to delete.
124 Learning whether the book is open by function
125 Report the row and column of the cell in a message
126 Writes sum formula
127 Add time as menu (most reliable)
128 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.
129 Remove sheet / page protection
130 Dialog box without userform
131 Protection protection menu
132 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
133 Determine the width of the active transaction sheet / page
134 Workbook name dialog window
135 Floppy formatting
136 Delete sheet / page with macro
137 Wav file playback 4
138 Forcing the computer to restart (method 1)
139 Combine textboxes in a single textbox
140 Userformda discount
141 Adding the commandbar
142 Find file dialog window
143 Sheet / page creation from a1
144 Just delete values ​​from the cell
145 Finding the print area
146 Delete a macro using code
147 Wmi network adapters
148 Right mouse menu
149 Column headers rc style and normal style
150 Add title dialog window
151 Slicer pivot table links dialog window
152 Give the column number to find the column
153 Combination dialog window
154 Select column to add red colored figures to a1
155 A1 message if more than 10 characters
156 B2de clock b3de stopwatch
157 Give the code address path from the cell to the code
158 Track and report user changes in an excel worksheet or workbook
159 Selects the columns in which the selected cells reside.
160 Dtpicker le current date
161 Textboxes are not empty
162 Date format of column in listbox
163 Dialog window "addin to make vba"
164 Codes collecting numbers in active cell
165 Flashing
166 Email extraction
167 Select cell identification
168 Workbook a1 1 increases each time
169 Exiting the workbook at x pressure in userform
170 Textboxa allows alphabetical backspace and spacebar
171 Warning when working on certain columns
172 Opening the desired site
173 Receive a message with a macro
174 The image on the form is empty when there is no contact picture in the file
175 Delete our file
176 Get data from combobox to listbox
177 Dialog window
178 Copy and paste formats of cells
179 Dialog window "evaluate formula"
180 Getting a temporary file name
181 Create a find menu
182 Folder deletion
183 It only enters numbers (0 when the text is entered) in a1 and collects continuously in a1
184 Run macro to enter a pressure in cell
185 Open auto filter (filter)
186 Show data in cell in txtbox 1
187 Gives the address and type of formula if the active cell contains a formula
188 Entering formula with message box
189 Highlight over values ​​highlight: after running this code, you will want the value you want to highlight all larger values.
190 Simultaneous selection of listbox indexes
191 Textbox can only enter digits-characters limited-empty
192 Macro corresponding to etopla formula
193 Save copy as dialog window
194 Selects from a1 to data cell
195 Tells the line number of the most recently entered data (in column a)
196 Transfer processor information to a cell
197 Open and close notebook
198 Returns the number of rows for the selection.
199 Sum of numbers from 1 to 10 with variable and loop
200 Finding the largest number in cells / which is the largest number in a field
201 Hides all sheet / pages and shows the sheet / page you want and vice versa
202 Let the macro work when it comes to cell
203 Save book close window select
204 Object properties dialog window
205 Question and answer in inputbox
206 Add menu to file edit menu
207 Print area
208 If "yes" in the "p" column
209 Sheet / page deletion without warning message
210 Update all pivot tables in the excel book / file
211 Im opening an excel file with vb code, but running the macro in this excel file
212 Welcome (opening macro)
213 Delete empty rows
214 Book opening macro by date (does not open the book if the specified date has passed)
215 Creating value in inputbox
216 Workbook unhide dialog window
217 Move to the desired cell on the desired sheet / page
218 Protect the sheet / page using macros and allow only unlocked cells
219 Encrypted entry is a number from 0-254
220 Right mouse on active sheet / page menu
221 Hides above rows with data
222 Program closes
223 Converts the number in the cell to lower or upper case and normal. H2o co2
224 Moves to the last registered cell in column a
225 Make visible if textbox box is invisible
226 Pasting to the end of the list
227 Layout options window
228 Storing data as a report
229 Saves the workbook with the date of the day - if any saves
230 Time in cell (by defining name to cell)
231 Auto-run macro you want at boot
232 Picture insertion window
233 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.
234 First letters in cell capital 2
235 I cannot see the zeros of the number i entered formatted
236 Record on the same ones
237 A1 1 is b1 march
238 If active cells are numerical (number) and greater than 500, make thick
239 Cut cancel & open copy
240 A macro that gives information to different cells based on the given value
241 Listing sheet / page names (tab name)
242 Generate random numbers
243 Serial options dialog window
244 How do i display only the working part of the sheet / page i am working on
245 Add comments to codes
246 Cell_formify_subscribe (mock)
247 Userform on top
248 Multisheet / page encrypted switch
249 Save only worksheets
250 Resolution finding2
251 Move the mouse cursor
252 Userformless form menu sheet / page select
253 Create your own extensions and functions in excel
254 Create a user-defined menu / create your own menu and assign a macro to them in the "extensions" section
255 Importing data into the listbox
256 Excel fonts
257 Label properties dialog window
258 Automatic upper case input in textbox 2
259 A cell that we want to be active when pressed
260 Printing a message to the excel helper
261 Copy and paste any excel sheet into another excel file
262 Deletes data without breaking the formula
263 Deletes the name of the cell
264 Closes the comment form
265 Formula goto dialog window
266 Change formula dialog window
267 Fonts in word
268 Increment number if print
269 Copies active sheet / page email
270 Zooming selected cells
271 Book total how many times which date and time opened
272 Untitled userform
273 Determine whether any range is assigned as a range name
274 Sweep
275 Initialization
276 A menu to the right mouse on a sheet / page
277 Tl and ytl
278 Data search with texbox
279 Find the first spaces and letter groups from right and left
280 Time counter
281 Add file folder
282 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.
283 Sequential sheet / page inserts
284 Workgroup dialog window
285 Prevents sheet / page deletion & naming
286 Graphical trend dialog window
287 Omission
288 Set the format of the text box
289 Send all pivot tables to printer
290 View dialog window
291 Using format painter to fit the format into a specific cell
292 A macro that deletes information from a given column?
293 Internet with internet explorer on sheet / page
294 Exceli closing process
295 Coloring the inside of the textbox with the mouse
296 Find function
297 Collects selected fields in status bar
298 Customize toolbar dialog window
299 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.
300 Email window of active book
301 Output as many as the number in the cell
302 User-defined (sheet / page count)
303 Draw a bar chart v.
304 Sheet / page deletion by typing in inputbox
305 Userform pending opening
306 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.
307 Write to the cell delete the range of data to be deleted (deletes from sheet / page1 and sheet / page2 on sheet / page1 to a2b2)
308 Scroll right
309 Ytl in textbox
310 A value in the combobox is already selected
311 Userform 2 minimizing userforma and adding maximize button
312 Export selected cells to text file
313 Userformda time processor does not wear a 1 minute refreshes itself
314 Auto-fit data into cell
315 Formulated cell colored
316 Alarm clock
317 Capitalize sheet / page names
318 Excelde case
319 Records detailed formatted cells on the records sheet / page
320 Error message in macro codes
321 Convert double and single lines into different colors and designs (one line is bold and the other line is normal)
322 Displaying the sum of any column values ​​in the listbox in the textbox
323 Save the workbook according to the value written in the cell and assign the value of that cell as the name of the excel book
324 Opening all excel files
325 Macros box and macros appear
326 Extracts from column a to be unique2
327 Sorts words with commas
328 Determining the excel version language
329 Calculate areas of shapes
330 Or in excel
331 Open userform in another workbook
332 Fetch last row and column number
333 How many times have the book been opened
334 Deletes formats in selected cells
335 Date and time backup
336 Does excel drawing?
337 Show excel file in full screen or exit full screen
338 Sort the days of the month into textboxes when you select the year in combobox1
339 Protect worksheet: you can use this macro code if you want to protect your worksheet. All you have to do is specify your password in your code.
340 A cell with a formula
341 Dialog window "set manager"
342 Dial up
343 Encrypted entry when cell is selected
344 Select red number and write to g12
345 For full screen
346 Row deletion
347 Formulated cell deletion
348 Commandbutton
349 Enter data with message to a1 and see the data in a1 in the message box
350 Highlight the difference in rows: and using this code you can highlight the difference between two rows (corresponding cells).
351 Starting from the active cell, starting from the number in b1 increments by 1
352 Search for a file and confirm it
353 Extract dialog window
354 Color counting
355 Locks only formulated cells on sheet / page others remain open
356 Custom views window
357 Size dialog window
358 List sheet / page names 2
359 Listbox entry to new book
360 A1 i 1 increment
361 Same sheet / page have alert 2
362 Hides sheet / page2
363 List formulas on new sheet / page
364 Write to cell e10 to scroll right to left
365 Select find additional or double ->
366 Mini email
367 Calculating message in macro
368 Font dialog window
369 Registration by date and sequence number
370
371 If a1 is 0, hide a10: a20 if not
372 Save each worksheet as a single pdf: this code simply saves all worksheets in a separate pdf file. You just need to change the folder name of the code.
373 Find the word in a cell
374 The size of an xls file in a folder or directory
375 Format text dialog window
376 Excel output with userform x
377 Numbers and codes from a1 to b1
378 Show the letters in the selected cell one by one
379 The first letters capital in the cell 1
380 As soon as your table opens, you are on the internet:
381 Gaps between sequence numbers c5: c20
382 Increase active cell 1
383 If a1 is 0 on the active sheet / page, b1 is the b1
384 Add graphical data dialog window
385 Save as dialog window
386 Sort by bcd columns respectively.
387 Delete sheet / page & block naming
388 The selected region consists of how many different areas (squares)
389 Show / hide custom toolbars & remove / restore excels local toolbars
390 Hello when the program opens
391 Api that finds which key is pressed
392 Row column hiding
393 Uppercase on the sheet / page 1
394 List sheet / page names from a1
395 Double-line message box 2
396 Saves data
397 Background flashes
398 Delete the selected cell from the listbox.
399 Userform s title moves
400 Subtotal with auto filter
401 Write numbers to a1: a5 and warns c1 if their total is less than 100
402 Delete a cell if the name is lowercase
403 You have 3 rights to the encrypted login.
404 Forcing numeric input to textbox
405 Â Â and column hiding process of your workbook
406 Save a dated and undated book with a cell name
407 Learning cell names
408 B5 is full if a5 e 1b6 is full a6 or 2 in the form of a column with a macro can print automatic sequence no
409 Do you want round userform
410 Remove all toolbars
411 A1 when writing the date and time
412 Column transfer month
413 To delete hyperlinks
414 Shift the entire column of the selected cells.
415 Dialog window "set tuple editor in rows"
416 What week of the year (by formula)
417 Only one view of data in the combobox
418 Import form with macro
419 Conditional numbering in a1
420 A1 = 1 c1 = 3 column b be hidden. Sheet2 is a1 = 1 b1 = 3
421 Create a new sheet / page with the name in a1
422 Penny in the textbox 1
423 Add alerts to pushbutton commands
424 To play a wav file in your current directory
425 Mouse cursor hourglass
426 Close the active visual basic form
427 Delete an image on a sheet / page
428 Open the form in another open excel worksheet
429 Gallery 3d column dialog window
430 Delete certain sheet / pages (except sheet / pages a b and c)
431 Comboboxta sorting
432 Undergraduate program
433 Prints selected areas on a sheet of paper
434 Find or find the number on the sheet / page
435 Fixed to be assigned to commobox
436 Whether to print straining
437 Selected cells are colored
438 A macro in a merged cell
439 Highlight the maximum value in range: controls all selected cells and is highlighted by the maximum value of the cell.
440 Closing a workbook without warning
441 Importing the dtpicker date value into a cell
442 Dialog window "appmove"
443 See the old value in the modified cell
444 Move to desired cell
445 If the form is full, get the second form and print
446 Collecting / counting colored cells (how many cells in the color i want)
447 Rectangle deletion
448 Custom footer right file path right book name
449 Font properties dialog window
450 Show changing cells
451 Round number 4
452 Dialog window "scenario cells"
453 Cells are filled with colors according to the values ​​of the cell
454 Delete rows that match a specific criterion
455 Detecting and selecting rows with single row numbers
456 Calculate how many sheet / pages are there
457 Filter by font color in cell
458 Update connection dialog window
459 Automatic filtering on active sheet / page
460 Edit array dialog window
461 M-n and o cell
462 Adding formulas to different cells
463 Remove standard toolbars in excel
464 Uncheck optionbuttons
465 A16: selects g28 cells and sets to 0
466 Sort sheet / pages by a-z or z-a
467 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. "
468 Delete every 5 min without warning if there is data between a1: a3000
469 Add-ons window
470 Form opens
471 Sheet / page copy with input
472 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
473 The data you receive in combobox is changed to big week
474 Get optionbutton1 checked at first boot
475 Errorbary dialog window
476 When i right click in any cell in excel, i want the "print" command to exit
477 Sort sheet / pages a to z
478 Sorting sheet / pages alphabetically
479 Marquee
480 Open connections dialog window
481 Hiding row is solved in second click
482 Whether the sheet / page has protection
483 Convert roman numbers to arabic numbers: sometimes it is really hard to understand roman numbers as serial numbers. This code will help you convert roman numbers to arabic numbers.
484 Adds months as sheet / pages and goes to that day
485 Use 17 if nested
486 Hyperlinks to sheet / pages from the active cell
487 Type b1e as the number changes in the same cell
488 The line containing the active cell is colored
489 Create a new sheet / page for workdays
490 Multisheet / page ground color
491 Select more cells to expand selected region
492 Shut down computer with macro
493 Row of columns row of columns
494 Lists the named cells in detail on the wb_names sheet / page
495 Listboxing if the information in the combobox is equal
496 Gallery 3d pie dialog window
497 Deletes duplicate records (duplicate records)
498 Style window
499 Textbox date example
500 Find excel file hide


aaaaa