Free Excel Macros (VBA)

Enter keywords related to the macro you are looking for.

Free Macros
NoMacro Name
1 Added 7 lines between line 1 and line 2
2 Add new toolbar
3 Save each sheet / page separately as a book
4 Return to userforma when you close print preview 2
5 Codes to manually select the rows and columns you want to print
6 Alert message --- message after 100 beep
7 Conditional wav ringing
8 Show all hidden rows and columns
9 If more than 2 characters are written in textbox, the other textbox will send a message.
10 Protect sheet / page by hiding column c
11 For normal display
12 Constant values ​​to be assigned to combobox
13 Learning excel version
14 Listbox filtering
15 Chart wizard dialog window
16 Writes the name of the sheet / page and the sheet / page number of the footer.
17 Make a cell currency
18 Term userform 2
19 Round number 2
20 Minimizing active workbook windows
21 Backup
22 Who opened the file 2
23 Rounding formula in cells 2
24 Rows and columns set in cm
25 Specifies the converted cells that converts uppercase to lowercase. (toggle)
26 Make the font in the cell bold and underline
27 Collect certain cells on separate sheet / pages
28 Search for a file and confirm it
29 Sheet / page names in alphabetical order
30 Receive warning messages on certain dates
31 Hide blank lines
32 If you say your macros are hidden
33 Run macro when sheet / page is activated
34 Writing a message to error 1
35 Determining that a row or column is empty
36 Adds sheet / pages based on data in column a and writes data up to column d
37 Saving if cell a1 is empty
38 Empty lines are not listed in the listbox.
39 Send alert e-mail from microsoft outlook
40 Print and number the sheet / page to the desired number...
41 Seriesx dialog window
42 Digitization macro
43 Copying the active sheet / page
44 Dialog window "check box properties"
45 The selected region consists of how many different areas (squares)
46 Count column a
47 Encrypted entry when cell is selected
48 Textbox and combobox
49 Search find copy to other sheet / page
50 0 so that zero is not shown in the entire workbook
51 A shortcut to find out how many people are on the list.
52 Data scrolls
53 1. Pir copies 10 sheet / pages and adds. Pir
54 New sheet / page with the name in a1 + there is the same warning
55 Selecting tab and textbox content 2
56 A1 to each data entry b1c1 respectively, always writes to the side column
57 Do you want the active cell to go to the top of the sheet / page?
58 Learn the number of sheet / pages in the message by opening
59 View the codes of the desired macro
60 Add a comment to a cell
61 Dialog window "color palette"
62 Message when the sheet / page is active
63 Delete images on all sheet / pages
64 Delete files
65 Show sheet / page2
66 Options table dialog window
67 Reboot when macro finishes (loop)
68 Calculator on / off
69 Remove decimals from numbers: this code helps you remove all digits of the digits in the selected range.
70 Find out which sheet / pages are protected
71 Open the sheet / page with the name in a1
72 New document opening window
73 Lists xls files in the specified path from the active cell
74 Write your welcome name at the opening hello.... Desin
75 Sort worksheets: this code will help you sort worksheets in your workbook by name.
76 Workbook a1 1 increases each time
77 Learning user name and pc name
78 Identify the letter label of a column
79 Currency format-currency in textbox
80 Copying entire folder
81 Force excel to save before closing
82 Filter 2 date ranges in comboboxes listbox
83 Find macro
84 Excel file protection
85 100 messages with the selected cell
86 Writes months to a combobox to add to your userform
87 Sorts sheet / pages
88 Dialog window "add toolbars"
89 Hiding external rows in colored cells
90 Resize all graphics on a worksheet: make all graphics the same size. This macro code will help you get all the dimensions of the same chart. You can change the height and width by changing graphics in macro code.
91 The data in the cell appears as a footer on the other sheet / page
92 Support dialog window
93 Change font color font in cells
94 Sending email with macro
95 Deletes the top empty cells from the last full cell on the sheet / page
96 Formula goto dialog window
97 Add menu to file edit bar delete
98 Display of the sheet / page with the screen resolution set to 800x600
99 Name the active cell or selected cells
100 Right mouse menu on sheet / page
101 Download files from the internet
102 Move from the active cell to the left
103 Find the textbox in the sheet / page (must write all)
104 Clearing the clipboard after a copy command
105 Select by intersecting full row and column (perfect)
106 Macro running macro
107 Print out the specified range of cells
108 Cell format is the same as in the textbox
109 A1: select d4 activate b2
110 Data changes
111 Dialog window "list box properties"
112 Open window
113 Close only one of the two excel files open.
114 Change connection dialog window
115 Column delete
116 Dialog window
117 Pc shutdown codes
118 Dialog window "evaluate formula"
119 Add 0 zeros to the beginning of the digit in the textbox
120 Move window dialog window
121 Entering formula with message box
122 Write the days of this month to the right write the day to the child cell and color the weekends
123 Create publisher dialog window
124 Double-click the address in the listbox and the form closes
125 Listbox file open close delete
126 History transactions 1
127 Calls sheet / page protection menus
128 Textbox uppercase turkish character problem
129 View options window
130 A1: j44 hiding external cells
131 Pie diagram drawing
132 Format cell window
133 Calculate how many sheet / pages are there
134 Color options window
135 Hide number of columns from 1 to 26
136 Go to the first and last row in the listbox with spinbutton.
137 Force
138 Receive a message after each data entry
139 Double-click the address in the listbox and close the form2
140 Copies active sheet / page email
141 Block save as
142 Cell protection window
143 Folder opening
144 If you enter data between a1-a20
145 Checkbox
146 Automatically save file name when saving different
147 Import the comment in the cell into the textbox
148 Deletes formats in selected cells
149 Untitled userform
150 Seriesy dialog window
151 Active default printer also prints
152 Love the one who moved. (unmovable userform)
153 View dialog window
154 Capital letter in column c
155 Calculate course averages
156 Makes 3 cells thick from bottom to bottom on active sheet / page
157 Delete that row if the name in the cell is lowercase
158 Program closes
159 Go to sheet / page3 in double-click
160 A1: a1000 patch the same
161 Array method select sheet / page
162 Listing sheet / page names (tab name)
163 Cut cancel & open copy
164 Recording on the same
165 Wmi network adapters
166 If there is data on the selected cell, it selects them. Selects the first cell after the first empty cell.
167 Still userform header
168 Get the warning you want wherever you want...
169 Folder search
170 2 move data between listboxes
171 If the sheet / page is blank, inserts the date in the footer and prints if not
172 Delete rectangle on active sheet / page
173 Convert formulas in selected cells to value 2
174 Finding a birthday
175 Module hiding
176 Print the entire workbook
177 Remove date time: you can use this code if you are spending time with the date and want to remove it.
178 Finding the day of the week n.
179 Automatic calculation enabled-ineffective
180 Commandbutton escapes not clicking anymore
181 Get the alert you want wherever you want
182 Currency format
183 To call a macro from within a macro
184 Select empty cells
185 Excel file working on cd
186 Scroll right
187 Adding values ​​of cells of a particular color, for example, what is the sum of cells of yellow color?
188 All in one addition multiplication division
189 First full cell from right to left
190 Asks for unprotect password at boot
191 Combobox vlookup
192 Printer window
193 Save as you want to keep coming
194 If a1 is 0 on the active sheet / page, b1 is the b1
195 Form automatically closes
196 Age calculation and message notification
197 Index cells vba code
198 New line code
199 The operation of different macros in response to the data entered in the cell in column 5
200 Format overlay dialog window
201 Index vba code
202 Shows sheet / page2 hides (2 clicks in sequence)
203 Sheet / page copy
204 Data series dialog window
205 Determine whether any range is assigned as a range name
206 Encrypted entry is a number from 0-254
207 Turning add-ons using macro on or off
208 Printing sheet / pages with data
209 Zoom in / out and make selected cells visible
210 Password
211 Dialog window "addin to make vba"
212 Find criteria matching in column c (from c2) and delete all rows (criterion combobox)
213 Wiping
214 Combobox can not get data a...
215 Gallery custom dialog window
216 Resolution finding2
217 Subtract the active cell 1
218 Display the formula in the cell / shows the english format of the formula in the cell
219 Goes to the empty row in the active column
220 Specifies the path and name of the book
221 View3d dialog window
222 Automatically filter excel sheet via userform
223 Check whether the message is numeric or non-numeric
224 Getting thundername in userform
225 Cd on and off
226 Detailed address column no column name row no row name
227 Printing selected data with option button
228  drive type show 5
229 Border window
230 How many times have the book been opened
231 Enter date in a1 to find out what week is in b1
232 Sorts data and finds name
233 Hiding
234 Adds months as sheet / pages and goes to that day
235 Autofill
236 More or less right left
237 Scans sheet / pages and prints previews if data is available
238 Delete empty rows in column one by one
239 Let macro run automatically if column 4 is executed
240 Codes collecting numbers in active cell
241 Warning message 4 x shaped warning window
242 Select the region table area
243 Hide the names of your sheet / pages
244 Receive a message with a macro
245 Vertical writing in label
246 Fonts in word
247 For full screen
248 Changes the name property of the sheet module named sheet1 in the workbook to mysh
249 Go directly to the sheet / page
250 Show the letters in the selected cell one by one
251 Saves the workbook with the date of the day - if any saves
252 Sorting sheet / pages alphabetically
253 Print userforma time remaining
254 Pending message
255 Sheet / pages other than certain sheet / pages
256 Blocking printing
257 List columns in rows
258 Message if textbox2 is greater than textbox1 2
259 Print preview dialog window
260 Erases others except sheet / page 1 without warning
261 Hide file menu bar
262 Paste into code section of userform
263 Userform dropdown in specified region
264 Dialog window "pivot field group"
265 Select column select from given cell
266 Page setup dialog window
267 Gallery pie dialog window
268 Disable / enable pivot data: you must use the excel option to disable / enable the getpivotdata function. But with this code, you can do it with a single click.
269 Search all files and folders
270 When 1 is entered in the cell on your sheet / page, the sentence corresponding to one is automatically written.
271 Assigning macros to the f9 key
272 Sum of numbers from 1 to 10 with variable and loop
273 Give background color by number on active sheet / page
274 Returns the number of non-empty cells in selections.
275 Go to sheet / page with inputbox
276 If data is present in cells a1: a5, b6: b10c1: c5 d4: d10 on all sheet / pages
277 Control of all attachments
278 Errorbarx dialog window
279 Class module retrieval
280 Audible clock
281 Starry effects
282 Prevents sheet / page deletion & naming
283 Create new line in message box
284 Workspace dialog window
285 Workbook saving
286 Numeric code of the background color of the cell
287 Add text dialog window
288 Reset optionbuttons in userform
289 Counts how many formulas exist on the sheet / page
290 Run macro when cell changes (expression in value, etc. ) / run macro when cell changes
291 Warns and deletes data when data is entered in the active sheet / page
292 Adjusting the screen resolution
293 Macro that locates the searched word and clears that line
294 Border to 3d cell
295 Run macro on cell
296 Windows search window
297 Capital letter 2 on sheet / page
298 Write folder path to cell b1 list xls files
299 Remove characters from a directory: remove only characters from the beginning of a text string. All you need is to reference a cell or add a number of characters and text to the function to remove from the text string. There are two arguments,rng" for the text string andcnt" for the number of characters to remove. For example: 1 incnt if you want to remove the first characters from a cell;
300 Printing all data in listbox1 to excel
301 Processes the opening date and time of the file in txt (bottom to bottom)
302 Just entering numbers in the textbox
303 Row height dialog window
304 Erase all graphic shapes and objects on the sheet / page to destroy
305 Saving a book in 5 minutes
306 Separates numbers from letters and numbers in a column
307 Locks only formulated cells on sheet / page others remain open
308 A1e force to enter date with vba
309 Book gets backup dated this day when opening
310 Copy a cell or cells
311 Displaying the sum of any column values ​​in the listbox in the textbox
312 Attendance codes workbook-level tasks & nbsp; it will help you perform it easily and with minimal effort. & nbsp; create a backup of a current workbook: this is one of the most useful macros that can help you save a backup file of a current workbook. Saves a backup file in the directory where your current file is saved. & nbsp; it will also add the name of the file to the current date.
313 Wmi video card
314 Blink if a1 = 1 and stop if 0
315 Api to create shortcut to my excel file on desktop
316 Using the name manager to determine whether a particular cell or region or anything is named
317 Add title dialog window
318 Show drive letter
319 Automatic separating numbers in textbox with a point in three digitals
320 Mini email
321 Value against names on sheet / page 2
322 Selection of filled fields and finding the last filled cell
323 Get total in listbox
324 Print your userform
325 Hyperlinks to sheet / pages from the active cell
326 Dialog window "analyze settings if pivot table is available"
327 Open mail dialog window
328 If in the cell (if) macro
329 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.
330 Desktop icon creation
331 Userform s title moves
332 2 forms at the same time
333 Save as and disable right click
334 Run individual macros based on active sheet / page
335 Deletes duplicate records
336 Listbox a lists the list of as in b in the textbox delete with commandbutton
337 Obey the commandbutton in userform3 according to the terms.
338 Userforma adds a minimization and maximize button
339 Application title
340 Deletes empty rows in column a and pulls up
341 Increasing the number of cells called numfact on opening and closing
342 Prevent deletion of formulated cells
343 Show all pivot table fields
344 Run macro at desired hour and minute
345 Select the sheet / page to the left and right of the active sheet / page
346 Create your own extensions and functions in excel
347 Automatic collection process
348 Penny in the textbox 1
349 Options view dialog window
350 Alarm clock
351 Let the macro work when it comes to cell
352 Deletes all sheet / pages except the active sheet / page
353 Learning version numbers
354 Format legend dialog window
355 Deleting its contents each time the textbox is selected
356 File backup
357 Update manually
358 Button scrolling data
359 Opening the desired site
360 Tl and ytl
361 Cell column selections
362 Textboxa (text box) girlilen type in the form of currency
363 Fetch the value of a cell on that sheet / page without opening the sheet / page
364 Print-out a5 paper without preview
365 Easy menu with right mouse
366 Userform click x to close excel
367 Chart options data labels dialog window
368 Open a word document
369 Comboboxta
370 Number of outputs by inputbox 1
371 File listing
372 Protect worksheet
373 Code that automatically deletes asynchronous data
374 Set the format of the text box
375 Extracts from column a to be unique
376 Cells cannot be passed empty b1: b8
377 Listbox or combobox header format
378 Search color
379 Choose a drag down
380 The following are the codes that list the data on the report sheet / pages to the report sheet / page in the selected date range.
381 Listing sheet / pages in the combobox and moving to the selected sheet / page
382 Deleting sheet / page names other than x and y
383 Sort process: sort three (3) columns simultaneously in excel
384 Create a text file 1
385 Click on the button to get data from the combobox
386 Finds if there is a written sheet / page in the cell
387 Selects full cells and converts them to lower case
388 Shrink the area used in excel and allow operation on only the desired cells
389 Macro run every 5 minutes
390 Uncheck optionbuttons
391 User-defined note function
392 Prevent saving excel file
393 Mouse cursor hourglass
394 List of spelling words
395 Closing message
396 Text to columns dialog window
397 Open a workbook and retrieve data from column a
398 Save the sheet / page to the desired location with the name in cell a1
399 Block cell drag & activate
400 A1: a10 collect message send total to a11
401 When you move to sheet / page2, select cell b1 and run the macro:
402 Selects down from active cell
403 Select the cell around the active cell
404 Delete txt file
405 Deletes the same ones in column b and leaves 1
406 Rectangle deletion
407 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
408 Let userform get from sheet / page1 to sheet / page2
409 Input data into cell with inputbox
410 Displaying the numbers entered in the textboxes on the basis of money
411 Cursor skips empty cell
412 Automatic opening of combobox.
413 Close button in userform
414 Integer in macro and rounding to ceiling
415 Copy data from pdf file and paste to excel file
416 Book save
417 Open the my documents folder
418 One-click check in column d e
419 Deletes the name of the cell
420 Printing the value of the buttons to the lab
421 Copies the abc column to the same directory txt file closes
422 Watermark printing (faded font on sheet / page background)
423 Protect the sheet / page using macros and allow only unlocked cells
424 Vba insert file dialog window
425 Import text file dialog window
426 Processor speed
427 Printing a message to the excel helper
428 Import only full cells into listbox
429 Add sheet / page if a1 is 1
430 Undo the last operation using a macro
431 Save workspace dialog window
432 Go to cell
433 Shift the entire column of the selected cells.
434 Imprison
435 Collect listbox send message
436 Dialog window "save new object"
437 Gather sheets of a sheette
438 Listing in listbox
439 Find formula dialog window
440 Printer testing
441 File search (whether or not)
442 Active cell color
443 Dated copy
444 Tells the column with the most recent active cell
445 Dialog window "pivot table wizard"
446 Select cells to delete 2 kinds of bullet (3 clicks in turn)
447 File cd rom checks your name does not keep closing
448 Book backup
449 Macro to hide the sheet we will write to open the macro to ask him to know the password
450 What week of the year (by formula)
451 Date and time backup
452 Makes sheet / page horizontal and prints cell a1
453 Cell selects specific active column
454 Divides the text in the active cell into letters (divided by 3 characters into columns)
455 Print value in a1 to txt file
456 Highlight specific text: suppose you have a large data set and want to control a specific value. You can use this code for this. When you run, you receive an input box to enter the value to search for.
457 Extracting data from a comboboxa column
458 If logic
459 Import file
460 Delete a link on a sheet / page
461 Book auto-save
462 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.
463 Import the active cell into listbox and textbox (using spinbutton)
464 True-false control on a given sheet / page
465 Print hidden sheet / page
466 Storing data as a report
467 There are 3 text boxes on the userform and we want the value of textbox1 to be 2 and 3
468 Sheet
469 Status bar macro with a message waiting
470 Computer name
471 Copy chart dialog window
472 Copy and paste one region into another
473 10 sec message
474 Font dialog window
475 Dialog window "solving the pivotfield group"
476 Add months as sheet / pages
477 Hides empty rows in column c
478 Mail editor mailer dialog window
479 I want it to work when i press f9
480 The data you receive in combobox is changed to big week
481 Gathering multiple names under one name with spending
482 Print dialog window
483 B3e enter data insert web sheet / page as sheet / page
484 Writing code
485 Makes your table full screen
486 Enter formula every 3 seconds
487 Sheet / page copy (with macro)
488 Copy and paste any excel sheet into another excel file
489 Determining the excel version / version
490 Routing note dialog window
491 Opening macro (requested sheet / page)
492 Open all excel files in folder
493 Message or macro according to the value in the cell
494 Save book you specify name - notifies you by message
495 Name of the currently active sheet / page currently in use
496 B4: h23 external cells locking and unlocking
497 Email inquiry in textbox
498 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.
499 Run macro codes when you enter values ​​to a1
500 Double record blocking (macros solution)