Free Excel Macros (VBA)


Enter keywords related to the macro you are looking for.

Free Macros
NoMacro Name
1 Block cell drag & activate
2 Putting / removing protection on multiple sheet / pages
3 Worde writes a report with or without internet connection
4 Commandbutton escapes not clicking anymore
5 Scans sheet / pages and prints previews if data is available
6 To turn capslock on
7 Automatic calculation enabled-ineffective
8 Border dialog window
9 Reset optionbuttons in userform
10 Remove sheet / page protections
11 Opening windows help
12 Warning when working on certain columns
13 Import "first name" information in separate cells into separate cells
14 Shut down computer with macro
15 The data you receive in combobox is changed to big week
16 Sum of numbers from 1 to 10 with variable and loop
17 Dated copy
18 Turkish alphabetical sorting also sorts hidden sheet / pages
19 Add comments to the active cell with inputbox
20 Dialog window "cell protection"
21 Selects from a1 to data cell
22 Is there an excel file or not?
23 Send a message every 30 seconds (macro)
24 Register by combobox
25 Book backup
26 Blinking effect when you type x in cell a1
27 Entering data into the desired cell
28 Userformda date
29 The cursor goes to textbox5 even if textbox6 or textbox7 is clicked when the cursor is in textbox4
30 A range of cells cannot be selected on your worksheet
31 Delete sheet / page with macro
32 Link collection
33 If you choose 2nd place in combobox, eat k2
34 Conditional wav ringing
35 Number of full records
36 Hyperlinks to sheet / pages from the active cell
37 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
38 Recommended pivot tables dialog window
39 Yes and no macro execution
40 Change password with save as
41 Open a word document
42 Delete empty rows
43 Clock date functions
44 Dialog window "save new object"
45 Codes that prevent and open the vba window and access codes
46 Cells a1 to a3000 make red if there is any data and send the line completely to sheet / page 3
47 Specify file path and extension list in detail
48 Finds the last space word = pir (a3)
49 Gallery pie dialog window
50 Age calculation
51 Give the macro path to the combobox tryit without userform
52 The macro only works with the current file
53 Search the expression in the selected cell in excel
54 Closure of active and inactive books
55 Mp3 file playback
56 Sound when you enter letters in textbox
57 ; show all hidden sheet / pages and make them visible
58 Selects from the active cell to the right
59 Closing the users book
60 Let calculations from column a to column g (except g) calculate other open columns by pressing the button
61 Application. Ontime
62 Delete text file 2
63 Cut and copy column and paste
64 Gallery custom dialog window
65 Transfer empty cells from column b to column a
66 Calls sheet / page protection menus
67 Msg box alarm in 3 sec
68 If a1 is less than a3, it gives a message.
69 Conditional data entry into textbox
70 Name of the currently active sheet / page currently in use
71 Go to sheet / page with inputbox
72 Format charttype dialog window
73 Protect worksheet
74 Counting values ​​in a column
75 Bear automatically recognizing codes
76 Show cell add digits after comma
77 Makes your table full screen
78 Wav file playback 3
79 Status bar macro with a message waiting
80 Move from the active cell to the left
81 Clicking cell d2 expands the column where the cell is located and decreases when clicking another cell.
82 Font names in column a
83 Scale dialog window
84 Save copy as dialog window
85 Edit options dialog window
86 Find command on active sheet / page
87 Paste names dialog window
88 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.
89 Automatic separating numbers in textbox with a point in three digitals
90 Row and column width
91 Selects active column
92 To play a wav file in your current directory
93 Recall the notebook
94 File backup
95 Separates the word a1 in a sound and silent manner
96 Hiding formulas
97 Repeated registration warning
98 Create bar charts with macro
99 Cell area interrupt selected area interrupt
100 Dialog window "protect document"
101 Watermark printing (faded font on sheet / page background)
102 Select red number and write to g12
103 Add date to right header
104 Learn the latest registration date at opening
105 Copies the most recent data in column a to b1
106 All windows minimized
107 Show all hidden worksheets: also if you want to hide all worksheets where you have hidden the previous code, your code is below.
108 Macro running macro
109 Change object property at once
110 Backs up your book to a floppy disk
111 Locks only formulated cells on sheet / page others remain open
112 Print and number the sheet / page to the desired number...
113 Add a formula to a cell
114 Lists add-ons in excel from a1
115 Update a pivot table
116 Block changes in print preview
117 Take a picture (printscreen)
118 Run the same macro on other sheets
119 How to remove sheet / page protection
120 Wmi windows
121 Collection in textbox
122 Auto-fit data into cell
123 Border window
124 Merge scenario dialog window
125 Dtpicker le current date
126 Export selected cells to text file
127 Assigning random numbers as a value to cells in the selected region
128 Userform has no x
129 Converting number / number to text function (turkish)
130 Show data in cell in txtbox 1
131 Find and list them in a message
132 Show toolbar dialog window
133 Finding the day of the week n.
134 Leave space between textboxes
135 Macro after message
136 Run macro on line 4
137 Explorer opening full screen
138 Â advancedsome of the code you can use to prepare an advanced task in your electrical tables. Select the selected range as pdf: select a range run this macro and obtain a pdf file for the selected range. This is really cool.
139 Open connections dialog window
140 Determining that a row or column is empty
141 Multisheet / page appears when combobox is empty
142 Message if textbox2 is greater than textbox1 2
143 Select cell area
144 Write value to another cell
145 Redirect cell alert to other cell
146 Column transfer order by deleting spaces ci
147 Selects from the active cell to the left
148 Color options window
149 Collecting and dividing with macro (percentage)
150 Save and close book automatically
151 Checkbox
152 Email inquiry in textbox
153 Converting alphabetical column tags numerically
154 Does not print without filling cells
155 Create a sequential and cell-wide textbox
156 Determine whether the cell is empty
157 Inserts and deletes annotations with the date and time in the active sheet / page
158 Cancellation of print preview commands
159 Add comment to selected cell
160 Parsing dialog window
161 See buttons and numbers
162 Active cell color
163 Delete the line that is registered with the help of the button
164 Enter data with message to a1 and see the data in a1 in the message box
165 Freeze panes
166 Magnifies the screen of the opened book
167 Exiting the workbook at x pressure in userform
168 Custom footer right file path right book name
169 Deleting sheet / page names other than x and y
170 Mail next letter dialog window
171 Just delete values ​​from the cell
172 Remove decimals from numbers: this code helps you remove all digits of the digits in the selected range.
173 Listbox entry to new book
174 Enter number in textbox see result in label
175 Saving if cell a1 is empty
176 Hides sheet / page2
177 Import the active cell into listbox and textbox (using spinbutton)
178 Selects the desired cell to go to
179 Hides all rows and columns
180 Inserts double zeros at the beginning of numbers entered in specific cells on the active sheet / page
181 Background of cells "a1: m8" flashes
182 Sort sheet / page names
183 Penny
184 Warns if textbox is less than 10
185 Assigning a macro in the message box yes no
186 Hide empty rows
187 Fully closed
188 Zooming selected cells
189 Reverse printing
190 Book backup to floppy disk
191 Gallery bar dialog window
192 Number format 2 digits after comma
193 Print the sheet / page name
194 Calculator on / off
195 Filter the same values ​​in column a on the next sheet / page and add the totals in b
196 Creating a new key in register
197 View dialog window
198 All letters capital spelling
199 Forms do not allow x to exit
200 Using the name manager to determine whether a particular cell or region or anything is named
201 Enter cancel on sheet / page
202 Get information from the registry
203 Hard disk formatting
204 Deactivates the close button at the beginning of the userform (multiply the userform does not close)
205 Displaying numbers in text
206 Gives the address and type of formula if the active cell contains a formula
207 Hides rows whose totals are equal to zero
208 Square root calculator: you can use this code to calculate the square root without applying a formula. Checks all selected cells and converts numbers to square.
209 Find and list
210 Check the same data on the active sheet / page
211 In the cell next to the month (according to the data in the abc column)
212 If a1 is empty (if you delete it) 10
213 Add and delete menus
214 Textbox activation
215 Collects selected fields in status bar
216 Find-change-delete-save macro
217 Autofill formula to a region
218 Summary information dialog window
219 Cancellation of file layout menus and new menu
220 A hyperlink down your sheet / page from the active cell of the sheet / page
221 Print value in a1 to txt file
222 Receive warning messages on certain dates
223 Tl and ytl
224 Zoom in / out and make selected cells visible
225 Macros box and macros appear
226 Select the most recent cell
227 Visual and beautiful userform
228 Output from the printer as many as the number in the cell
229 Listing colors
230 Date format in active sheet / page and target cells
231 Sheet / page showing at opening and not appearing at closing
232 To ignore the error message
233 The requested sheet / page comes in the opening
234 Creates folder with book name save each sheet / page separately
235 Write the difference between two hours in minutes format
236 Left click on cells c8: c18 to display right mouse menu
237 Hide d1 if cell a1 is full show if empty
238 Pending message
239 Mouse cursor hourglass
240 Just enter numbers in the color cell: msgbox
241 Open the text box with the button to transfer data.
242 Name of active sheet / page in cell a1
243 Moving excel file into folder
244 E1: collects e15 and writes a1e
245 Date printing on textbox
246 Add script dialog window
247 Turkish mathematical terms
248 Transfers full ones to another sheet / page
249 Make excel userform exe
250 Date format in textbox
251 Row of columns row of columns
252 Adjust or change column width
253 Distinguish two adjacent columns until the end of the column
254 Gets an intermittent total in column c
255 Opening userform hold 2
256 Set the showmodal status by writing code.
257 Create a new sheet / page with the name in a1
258 Book name in the lower left corner of the custom footer sheet / page1
259 I want it to work when i press f9
260 Show excel file in full screen or exit full screen
261 Breaking sheet / page protection
262 Location identification macro
263 Run macro based on value in cell
264 Find with inputbox
265 Sheet / page protection automatic filter open
266 Open all excel files in folder
267 Change the color of a cells font
268 Web options fonts dialog window
269 50000 rows extraction form to g-pillar (ejects f2 from e2)
270 Writes the name of the sheet / page and the sheet / page number of the footer.
271 Save each sheet / page separately as a book
272 Set background image dialog window
273 Desktop icon creation
274 To call a macro from within a macro 2
275 Change the title of your workbook as desired
276 Selects full cells and converts them to uppercase
277 Select the previously processed cell
278 Textbox and combobox
279 Save as
280 Specifies the path and name of the book
281 Text in the text box
282 Gallery 3d surface dialog window
283 Textbox date format
284 Letter exchange
285 Resolution learning
286 Color change when i come to the buttons with the mouse
287 Tab order dialog window
288 Run the command button in the other form
289 Hiding columns
290 Row sort up to whole column
291 Selects 7 lines down and 7 lines up from the active cell
292 The location of the userform.
293 Formulated cell colored
294 Suspended cells: select the cells and run this code; remove all the cells in the selection with the data you lost.
295 Average collection in labeller
296 Table dialog window
297 Preview macro
298 Send list by excel
299 Prints the name of the workbook and active sheet in the active cell
300 Tells the column with the most recent active cell
301 Collection formula macro examples
302 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.
303 Hide number of columns from 1 to 26
304 Find file dialog window
305 Finds the last day of the month writes to the active cell
306 Inputbox add year as summer
307 Change sheet / page name
308 Add sheet / pages as menus
309 Find out if there is a formula in the selected cell
310 Background flashes
311 Com. Ver from the form box to the lis. Box
312 Date collection in textboxes
313 Insert date as left header when sheet / page is active
314 Dialog window "check box properties"
315 File listing
316 Sorting sheet / pages alphabetically
317 Write the latest data in column a to b1
318 Find and copy and paste in macro
319 Copy picture dialog window
320 Workbook tab pane dialog window
321 Delete rows that match a specific criterion
322 Delete empty sales
323 User-defined function
324 Translate text to cell event from userform
325 Remove negative marks: this code checks all cells in the selection and makes all negative numbers positive. Select a range and run this code.
326 Remove sheet / page protection
327 Opening a calendar in a cell
328 Copy textbox content
329 Preventing more than 2 digits or missing data after comma in textbox
330  show free space
331 Time counter
332 Requested sheet / page at opening
333 Userforma adds a minimization and maximize button
334 Highlight all cells in a worksheet with an empty but not visible field: some cells are sometimes empty, but have a single field. And so it is really hard to identify them. This code checks all the cells in the worksheet and will highlight all the cells with a single field.
335 Harddisk serial number import into cell a1
336 Force to enter data into textbox
337 List all toolbars
338 Finding the number of each item in the list using the vba and pivot table
339 Write numbers to a1: a5 and warns c1 if their total is less than 100
340 Auto-run macro you want at boot
341 Delete the file edit menu
342 Automatic date format in cell
343 Scrolling
344 First letters in cell capital 2
345 Userform pending opening
346 Learning operating system
347 Open window
348 Object assignment dialog window
349 If the form is full, get the second form and print
350 Del key should not work in column 2
351 Select full ones (row variable column fixed)
352 F2 enter function in excel
353 Moves to the first empty cell in the column
354 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.
355 Split window vertically
356 Adding a password to commandbuton
357 Assigns a value to the desired cell on the specified sheet of an excel workbook that is open
358 Click on cell to open userform
359 Fonts window
360 Calculator calls
361 Completes the number in the cell to one thousandth
362 Resolution finding
363 Dialog window "evaluate formula"
364 Get rows in ascending order
365 The following are the codes that list the data on the report sheet / pages to the report sheet / page in the selected date range.
366 Makes the last digit of the number in the cell 0 (zero)
367 Userform 3 hides the close button on the top right of userform
368 Continuous flash example in excel
369 Add save key to userforma
370 Reports the last full cells in columns on the desired sheet / page in the entire book
371 Beep sound decal
372 Userformun crossed out message box with warning
373 Copy picture window
374 Adding values ​​of cells of a particular color, for example, what is the sum of cells of yellow color?
375 1 more than 1 in the list
376 Random
377 Find macro
378 Convert to new tl and penny
379 Printing all data in listbox1 to excel
380 Selects the rows where the selected cells are located.
381 Open a form by sheet / page.
382 Save only worksheets
383 Lists xls files in the specified path from the active cell
384 If logic
385 Importing data from a text file (all data one by one)
386 Increasing the number of cells called numfact on opening and closing
387 Double-click on active cell to add subtotal
388 Go directly to the sheet / page
389 Adding formulas to different cells
390 Message if textbox2 is greater than textbox1 1
391 Textboxa only number
392 To assign a value to another sheet / page without selecting a formulated cell
393 Opening a word document
394 Collapse userform
395 Sum of digit values
396 Save as and disable right click
397 Copies the text from the rectangle on the active sheet / page to the cell
398 Excel file protection
399 If the sheet / page is blank, inserts the date in the footer and prints if not
400 Collects cells that are red between a1: d20
401 Transfer processor information to a cell
402 Gaps between sequence numbers c5: c20
403 Select the full area on the sheet / page
404 Listbox file open close delete
405 Undo --- undo
406 Click on one of the abcd letters on the sheet / page to print the desired
407 If there is data under the selected cell, it selects them. Selects the first cell after the first empty cell.
408 Pasting to the end of the list
409 Function calculating workdays
410 Guide lines dialog window
411 Assign value to cell
412 Formula replication
413 Reverse text, rewrite from end to top
414 Select the sheet / page to the left and right of the active sheet / page
415 Displaying the numbers entered in the textboxes on the basis of money
416 Hides the close button on the top right of the userform
417 Forced to enter password redirects to other sheet / page
418 Write sheet / page names from a1
419 Apply style dialog window
420 Add menu to file edit menu
421 Whichever cell is full (a2: e2) write it to the other cell (a5)
422 Group window
423 Macro to hide the sheet we will write to open the macro to ask him to know the password
424 Open the text box with the button to transfer data
425 Convert day to day: if you have a date on your worksheet and want to convert all these dates into days, this code is for you. Just select the range of cells and run this macro.
426 Userform 4 waiting for a certain time on the screen and then close the user form.
427 Print the user name in cell a1
428 Do not send messages when deleting sheet / pages
429 No userform x
430 Number of files
431 Close one form and open another
432 Send mail dialog window
433 Copy cells as images
434 100 button bar add remove
435 Same sheet / page have alert 2
436 Protect sheet / page by hiding column c
437 Write the same cell in all cells on the active sheet / page
438 The line containing the active cell is colored
439 Using format painter to fit the format into a specific cell
440 No warning when deleting sheet / pages
441 Checking whether the message is empty
442 Gallery area dialog window
443 Opening userform as closed
444 Userformu full screen code 2
445 Receiving messages after printing on the active sheet / page
446 Converting column letters to column numbers
447 Double-click column 2 to specify the row to add
448 One-click check in column d e
449 A menu to the right mouse on a sheet / page
450 Define format for all textboxes
451 Print area
452 Do not write in comboboxin.
453 Printing sequence numbers to comboboxes
454 Sort data by name order
455 T. C. Getting the current exchange rates of the central bank
456 Codes collecting numbers in active cell
457 Retrieve data from an encrypted closed file
458 Search in textbox1 find in textbox2
459 Encrypted entry when cell is selected
460 Select the 1st column
461 Show last names in cell 2 textbox
462 Index / table of contents
463 Reference types when printing a formula to a cell
464 Register with textboxes
465 Vat calculation 2
466 The background of cells a1: m8 flashes
467 I1: translates to 0 if data written in cells i13 is not equal to 0
468 Label properties dialog window
469 Show you all the hidden sheet / pages in order to show you the message?
470 Active letters
471 Web options pictures dialog window
472 Macro running depending on user name
473 Wmi network adapters
474 Does the macro work on the hidden sheet / page
475 Sorts words with commas
476 A copy of a sheet / page (specify its name)
477 Color change when the textbox object is selected with the tab key or mouse
478 Select column select from given cell
479 Select row
480 Comparison example with combobox
481 Converting a matrix to a vector
482 Writes months to a combobox to add to your userform
483 Copy the active worksheet to a new workbook: let us say you want to copy your active worksheet in a new workbook, just run this macro code and it will do the same for you. & nbsp; this is a great time.
484 Workbook options dialog window
485 Subscribe dialog window
486 File move
487 Select lines
488 Determining the name of the sheet / page and file containing the active cell
489 How many times has the file been opened
490 Message box double row 3
491 A1 will always meet in a2
492 Imprison
493 Set name save and close active sheet / page as book
494 Worde data transfer
495 Sheet / page1 a1b1c1 is full and column b is hidden and copy c1 i to sheet / page2b on a1b1
496 Double-click prohibited on sheet / page
497 Create a new book creates a book that starts with the name of the book
498 In the data message box in the cell 2
499 Limit the number of characters to be entered in a text box on any form
500 Grabs one form opens the other


aaaaa