Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/dbswav/public_html/excelwithkenan.com/hazir_makrolar.php:447) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/dbswav/public_html/excelwithkenan.com/hazir_makrolar.php:447) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Free Excel Macros (VBA)


Enter keywords related to the macro you are looking for.

Free Macros
NoMacro Name
1 Open a txt file on a sheet / page and import its contents the name of a txt file is the sheet / page name
2 Draw a box / shape in excel
3 Add toolbars to combo box and select from there
4 Select cell
5 Update manually
6 Return enter key
7 Check the same data on the active sheet / page
8 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.
9 Coloring sheet / page names
10 Adjusting the screen resolution
11 Adding characters to the end of the formula
12 Records detailed formatted cells on the records sheet / page
13 If cell a1 is 1, the message box should start and write the excl.
14 Userform 5 term userform-2
15 Macro corresponding to etopla formula
16 3 x shaped warning messages
17 Macro that locates the searched word and clears that line
18 Column a separates the same value as the print area
19 A macro with rows and columns
20 Hide sheet / page
21 Apply names dialog window
22 Delete all pictures
23 Userform 7 prompts userform when crossed
24 Add image dialog window
25 Numbers that are the same
26 Invalid warning message exiting userform with x
27 Open dialog window
28 Message box samples
29 Scans sheet / pages and prints previews if data is available
30 A1e force to enter date with vba
31 Gallery pie dialog window
32 Prints the name of the active workbook in the active cell
33 Selecting all of the content when the textbox is clicked
34 Same sheet / page warning
35 Enter cancel on sheet / page
36 First letters in cell capital 2
37 Deletes empty rows below the active cell
38 Adds months as a sheet / page and writes the days of the month and goes to the active month and day
39 Format graph dialog window
40 Change formula dialog window
41 Click-to-listbox
42 Selects from top to bottom if the column contains data
43 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.
44 Comparison example with combobox
45 Cut cancel & open copy
46 Column transfer month
47 Dialog window "set tuple editor in columns"
48 Com. Ver from the form box to the lis. Box
49 Row sorting
50 Write your name with file backup message box
51 Interest calculation
52 Collection with textboxes
53 About listbox
54 Api to create shortcut to my excel file on desktop
55 Assign a total to a variable v.
56 Opening system date
57 Detection of a region named with the name manager / is there such a name given anywhere?
58 To delete sales with faulty cells
59 Adds todays date to the active cell
60 Highlight active row and column: highlight active row and column
61 Copy and paste with macro
62 Msgbox according to condition
63 Name the active cell or selected cells
64 Make the first letter of all words in the selected region capitalized and the other letters lowercase
65 How many jpg files are in the folder?
66 Select the most recent cell
67 Label ranges insert window
68 File backup
69 Only one view of data in the combobox
70 If a5 = 2, do not open the userform
71 Cells colorful flashes
72 Save as you want to keep coming
73 Timer message example
74 Calculate how many sheet / pages are there
75 Sheet / page showing at opening and not appearing at closing
76 Deleting empty rows2
77 Transfers full ones to another sheet / page
78 To make an empty cell the same as an upper cell
79 Inserts months as sheet / pages specifies days in detail
80 Adjust the screen resolution
81 Merge two separate columns with data
82 Slicing settings dialog window
83 Codes that prevent the cursor from moving when the macro is running
84 Importing filled ones from cell into listbox
85 Textbox date example
86 Whether to print straining 2
87 Show all rows and columns: you can use this code to do this one at a time, rather than overwriting individual rows and columns.
88 Enable a1 reference style: this macro code will help you enable the a1 reference style without using the excel options.
89 Protection protection menu
90 Importing data from a sheet / page in the listbox
91 Write e1 cell and e15 cells total a1 e
92 Counting voices in textbox
93 Takes dated backup to current folder
94 Sheet / page protection and removal
95 A cell that we want to be active when pressed
96 Undergraduate program
97 Selects the rows where the selected cells are located.
98 Shutdown and restart the computer
99 Add new toolbar
100 Informs you which sheet / page is active when you move from sheet / page to sheet / page
101 Clock in cell a1
102 Translate text to cell event from userform
103 Select tab and textbox content
104 Calculate the duration of the mp3 file (type the file path and select that cell)
105 Click any cell and scroll to the right to write the number of days in that month
106 Enlarging
107 Learning the file format of the drive
108 Format text dialog window
109 Update automatic
110 Automatic filter opening
111 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.
112 Makes all selected cells 0
113 Sheet / page protect unprotect
114 Day date time in message box
115 Select a print area
116 Moon learning in cell (defining function)
117 Assign value to cell
118 Who opened the file 2
119 List sheet / page names from a1
120 Select value in combobox
121 Email window of active book
122 Show all hidden sheet / pages
123 Delete selected data and row in combobox
124 References control
125 Import sheet / page names into listbox
126 Copies the sheet / page and creates a sheet / page dated yesterday and assigns the information into it
127 Double record blocking.
128 Hello when the program opens
129 History transactions 1
130 Transfer from combobox to sheet / page
131 Form calls
132 Disable add-in in xla file
133 Magnifies the screen of the opened book
134 Text animation
135 If you enter data between a1-a20
136 Set the showmodal status by writing code.
137 Output as a word sheet / page
138 Convert formulas to value
139 Printing sequence numbers to comboboxes
140 Delete a file on the computer
141 Email selected cells
142 Change connection dialog window
143 Lock the book. Speak read - only read - only. Hides macros
144 Repeated registration warning
145 Manage relationships dialog window
146 Is the size of a file in bytes?
147 One click output
148 Prints the name of the workbook and active sheet in the active cell
149 Close all forms showmodal false ones 1
150 Separating merged cells with macro
151 Adding date to a1 when closing book
152 Clearing the clipboard after a copy command
153 Date and time in label
154 Get information from the registry
155 Excel file working on cd
156 Processes the opening date and time of the file in txt (bottom to bottom)
157 Special expense discount macro
158 Code that finds the number of sheet / pages 1
159 Cancel copy and paste
160 Warning message 4 x shaped warning window
161 If the value of cell a1 is lower than the value in cell a3, let macro work
162 Opening calculator
163 Subfolders
164 Exit procedure
165 Workbook options dialog window
166 Data transfer...
167 Multisheet / page encrypted switch
168 Remove decimals from numbers: this code helps you remove all digits of the digits in the selected range.
169 Assigning macros to the f9 key
170 Detecting whether there is an extension (or not in the excel library? )
171 Msg box alarm in 3 sec
172 Web options pictures dialog window
173 Which day is the answer to the question which day
174 Wmi windows
175 Adding the commandbar
176 Import file
177 User-defined (sheet / page count)
178 Close all forms showmodal false ones 2
179 Stop clock if b1 x
180 Add a comment to the active cell and set the font and point for that comment
181 Adding additem to the listbox with a "for" loop
182 Moves to the selected cell
183 Writes the names of all sheet / pages from the active sheet / page and cell and adds a link to the sheet / pages
184 Find-change-delete-save macro
185 Color active cells
186 Moves to the blank row below the last full row in the column
187 Save and close book automatically
188 Three cell jumps of the cursor
189 Finding a birthday
190 C lists folders in the listbox
191 Column width set 5
192 Trading with a single userform
193 Textbox and combobox
194 Still userform
195 Comparison; sheet / page1 sheet / page2 abc columns
196 Save a book by name
197 Print inside cells with a certain print area but only filled
198 Collapse column by data in cell
199 Bear automatically recognizing codes
200 Recall the notebook
201 Sparkline adding win loss dialog window
202 Mail logon dialog window
203 Using a macro to copy a module to another location
204 Adds a new sheet / page named month and year, together with the data a1: a5
205 Sheet / page names
206 Macro to hide the sheet we will write to open the macro to ask him to know the password
207 Fills the line spacing on the sheet / page
208 Add sheet / page write name to inputbox
209 Flashing articles
210 Print by increasing the value in the cell by 1
211 Adding formulas to different cells
212 Menu editor dialog window
213 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.
214 Assign file names to excele
215 Protects your worksheet works automatically filters
216 If the condition is satisfied
217 Warns and deletes data when data is entered in the active sheet / page
218 Retrieve data from an encrypted closed file
219 Formula replication by full row
220 Gaps between sequence numbers c5: c20
221 Hides blank lines on a sheet / page
222 Excel fonts
223 Putting and removing protection on the active sheet / page
224 Does excel drawing?
225 Delete our file
226 Msgbox warning
227 Update a pivot table
228 Hiding external rows in colored cells
229 Open window
230 First letters of textbox are capitalized
231 Link to a1 and open outloook with mail in a1
232 Guide lines dialog window
233 Userform 3 hides the close button on the top right of userform
234 Conditional formatting window
235 Flashing
236 Convert range as image: paste the selected range as an image. Just select the range, and after running this code, it automatically adds an image for that range.
237 Hide all sheet / pages except sheet / page 1
238 Opening all excel files with 85%
239 Refresh information in pivot table 1
240 Find the last cell before a space in the row
241 Moves the selected cell to the upper left corner
242 Processor speed
243 Delete a cell from a sheet / page in another book
244 Make sheet / page names in excel file invisible
245 Save and close completely
246 Cell
247 Cell selects specific active line
248 Sheet / page names in alphabetical order 2
249 Save as cell name a1
250 Errorbarx dialog window
251 Hide the desired column
252 Finding the day of the week n.
253 Double-clicking on listbox and retrieving values ​​from textboxa listbox columns
254 Errorbary dialog window
255 Sorts unordered names in column a of sheet / page 1 to a-z in column a of sheet / page 2
256 Internet with internet explorer on sheet / page
257 Put a leading character in the listbox
258 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.
259 Run macro when cell changes (expression in value, etc. ) / run macro when cell changes
260 B2c2d2 takes the date in a2 as day month month year
261 Rounding formula in cells 2
262 Add excel sheets as menus
263 Protects formulated cells
264 Inserts any number of rows from the active cell
265 Record on multiple sheet / pages with the same macro
266 Opening with the same sheet / page
267 Selects full cells and converts them to uppercase
268 Labelde date format
269 Term userform 2
270 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
271 Explanation of the formula
272 B3e enter data insert web sheet / page as sheet / page
273 Write to the cell delete the range of data to be deleted (deletes from sheet / page1 and sheet / page2 on sheet / page1 to a2b2)
274 Select cell values ​​with auto-color in specific table
275 Deletes duplicate records (duplicate records)
276 Print area
277 How many (number of drive)
278 Create your own extensions and functions in excel
279 Adding a-z alphabet in a range: you can add alphabets to your worksheet as you do serial numbers. You can find the code below.
280 Dialog window "color palette"
281 Receive alerts when changing data
282 Another command instead of "wait"
283 Sum of numbers in listbox in textbox
284 The value passed from the listbox to the textbox is output in the same format
285 Remove the formula bar
286 Data scrolls
287 Automatic uppercase letter 3 in textbox (for turkish character problem)
288 Finding the number of each item in the list using the vba and pivot table
289 Summer adds months to sheet / pages
290 Sort sheet / pages by a-z or z-a
291 Opens and copies the selected word document
292 Detailed report on harddisk
293 Ping the address in the cell
294 Commadbuton creation macro
295 Update pivot tables in all open excel files
296 Disables the close button at the beginning of the userform (userform does not close when multiplied)
297 Save optional data to sheet / pages
298 Save only worksheets
299 Conditional data entry into textbox
300 Number finding
301 Round number 3
302 Find-delete-change-save codes2
303 Words from an entire worksheet: can help you count all the words in a worksheet.
304 A1 = 1 c1 = 3 column b be hidden. Sheet2 is a1 = 1 b1 = 3
305 It doesnt delete even if a row is full in any column of the active row.
306 Add date and time in two clicks
307 Close one form and open another
308 Listing sheet / page names (tab name)
309 Adds intermittent ones in column c
310 Adds 1 to the numbers in column a writes to column c
311 Scroll bar properties dialog window
312 Rename the additem in the listbox
313 Deletes the top empty cells from the last full cell on the worksheet
314 Find macro
315 Zoom in / out or reduce the active sheet / page to a certain size
316 Loop
317 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.
318 Excel operators hk
319 Listing colors
320 Ignore book title a1
321 Non-movable userform
322 Time counter
323 Go to related sheet / page
324 Automatically opening the column at the desired width when you click on the cell
325 Show changing cells
326 Adding and deleting jpeg images
327 Userforma adds a minimization and maximize button
328 Double-line message box 3
329 Performance test
330 Dialog window
331 Sheet / page names in alphabetical order
332 Sorting of filters in combobox
333 Off without saving
334 Makes workarea1 0
335 2 move data between listboxes
336 Add dialog window
337 The macro only works with the current file
338 Enter date in a1 to find out what week is in b1
339 Entering the data in the listbox (ie without mouse)
340 You have 3 rights to the encrypted login.
341 Calculator on / off
342 Userforma adds a minimization and maximize button
343 Cancellation of menu and commands cannot be selected
344 Opening a file and entering data
345 Comboboxa manual data entry prohibited 2
346 Return to form when preview closes from userform
347 Add-remove button
348 Dictionary codes
349 Prints selected areas on a sheet of paper
350 Customization and return of toolbars
351 Function codes that find out what week
352 A1: j44 hiding external cells
353 Leaves 1 space between words
354 Entering data in msgbox la a1
355 Find-delete-change-save codes
356 Module deletion
357 Let macro run automatically if column 4 is executed
358 Cell format is the same as in the textbox
359 Give background color by number on active sheet / page2
360 First full cell from right to left
361 Merge window
362 Variety dialog window
363 A1 to each data entry b1c1 respectively, always writes to the side column
364 New webquery dialog window
365 Txt who opened the file on what date
366 Open and close notebook
367 Copy-paste blocking
368 Password opening
369 Does not enter a smaller value in the active cell
370 Opening dataform
371 Select column to say the number of full data
372 Collect thick ones
373 Print full area
374 Open the text box with the button to transfer data
375 Macro for seeing vba codes
376 Animated gifs userformda
377 Message box caption
378 For quick information entry on any sheet / page
379 Import the active cell into listbox and textbox (using spinbutton)
380 Delete rows
381 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.
382 Output from the printer as many as the number in the cell
383 Book every opening a1 1 increases
384 Hide and show from 10th line
385 Automatic fit of text width in description
386 Selects from the active cell to the right
387 Share workbook window
388 Object assignment dialog window
389 Delete cells that are the same as the macro
390 Book opening-copying-closing
391 Saving output
392 Sorts the sheet / page names as they are
393 Finds data
394 Easy menu with right mouse
395 Custom sort dialog window
396 Cd on and off
397 Alignment window
398 Forecastets dialog window
399 Window vertical splitting 2
400 B3 type and collect 10 pieces
401 Phone format in textbox
402 Paste names dialog window
403 Open a word document
404 Macro with hold
405 I want it to be white so that it doesnt appear on the printout.
406 Calls the browse folder window
407 Sheet / pages showing userform (with code without form)
408 Combobox can not get data a...
409 Select the region table area
410 Paste cells as values ​​
411 Shift selected cells down.
412 If we want the value of dtpicker to be a value from the database
413 Type in cell and make your font bold
414 Write to side cell
415 Automatic collection process
416 Copy paste
417 Breaking sheet / page protection
418 New line code
419 If action is performed in cell a1, cell a2 writes the modified date and time
420 Api that finds which key is pressed
421 Textboxes are not empty
422 Copy and paste operations
423 General options window
424 Macros that determine and cancel your workspace on your worksheet
425 Date format in textbox
426 ; show all hidden sheet / pages and make them visible
427 Pie diagram drawing
428 Run macro codes when you enter values ​​to a1
429 Only the print area down is selected even if there is only one cell
430 Warning message (anytime, anywhere)
431 Show sheet / page tabs in cell
432 Find the most recently used cell in a column
433 Convert formulas to numbers
434 Subscribe dialog window
435 Random numbering
436 Pivot calculated area dialog window
437 Delete files
438 Click on any cell to run the macro
439 Copy textbox content
440 For example, if macro is executed in line 4
441 Do you want the active cell to go to the top of the sheet / page?
442 Â 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.
443 Message if textbox2 is greater than textbox1 2
444 Sheet / page address and set column width
445 Time difference calculation
446 To play a wav file in your current directory
447 Calls sheet / page protection menus
448 Date format in active sheet / page and target cells
449 Is there one or more fields in the selected field?
450 Userform 2 minimizing userforma and adding maximize button
451 Allows textbox and numeric and backspace
452 Thousands separator in textbox
453 Set the font thickness
454 Combination dialog window
455 Learning screen resolution
456 Selects from right to left if there are values ​​in 2 cells next to each other
457 Print hidden sheet / page
458 View dialog window
459 Draw a border by cell width
460 Collects cells that are red between a1: d20
461 If more than 2 characters are written in the textbox, it will switch to the other textbox
462 Read the number in dollars = dollartext (a1)
463 Book opening (more than 1 file)
464 Select cell identification
465 Prevent saving excel file
466 Print preview dialog window
467 Register with textboxes
468 List sheet / page names 2
469 Selects the first empty cell after full cells. (for columns. )
470 Adds sheet / pages based on data in column a and writes data up to column d
471 Just select the cells used (region)
472 Copy data to textboka
473 Data limitation in textbox (max characters)
474 In the deletion of the last written sheet / page, type the following code in the exit button.
475 Selects from the active cell to the left
476 Create a user-defined menu / create your own menu and assign a macro to them in the "extensions" section
477 The data you receive in combobox is changed to big week
478 When you enter a value of a1 multiply by 10 write to a2
479 Hiding
480 Capitalize sheet / page names
481 Import the comment in the cell into the textbox
482 Does the macro work on the hidden sheet / page
483 X-shaped warning window
484 Dyes empty cells between cells a1: a10
485 Double-click the address in the listbox and the form closes
486 Collection in textboxes
487 Convert date to years: this code converts dates into the year of the month.
488 Save as with name in a1
489 The selected region consists of how many different areas (squares)
490 Frees table
491 Create shortcut to desktop
492 Commandbutton escapes not clicking anymore
493 Shows sheet / page2 hides (2 clicks in sequence)
494 Password before saving
495 Finds how many rows are selected
496 Delete the line that is registered with the help of the button
497 Open my documents folder with alt + f4
498 Double-line message box 2
499 Gives the address and type of formula if the active cell contains a formula
500 Bring some of the tool buttons as a separate menu at boot


aaaaa