Recording a Macro
Submitted by ravisagar on Sun, 07/06/2008 - 02:40.
The Easiest and the fastest way to learn Excel VBA Programming is by using the Recording Macro feature. This cool feature of Excel will record all the steps you perform on Excel sheet and generate a Code. You can later view the code and see how your actions are translated into VBA Code.
Procedure to Record a Macro:
1. Click Tools > Macro > Record New Macro
2. Enter the desired Macro Name and click Ok to start Macro Recording .
If you want you can also give a shortcut Key to Recorded Macro. Select Store macro in “This Workbook” so that the Recorded Macro is saved right inside the Excel sheet. If you choose this option and send the sheet to someone then the Recorded Macro will also be sent.
Note: If you store macro in “Personal Macro Workbook” then the Recorded Macro will not be saved inside the Excel sheet. Recorded Macro will be stored in Personal Sheet. Personal.xls file is created when a Macro is recorded to it for the first time and it is saved in \XLStart directory of MS Office. It is advisable to store the frequently used Macros in “Personal Macro Workbook” so that they are always available from any sheet but if you send the Excel sheet to someone, the Macro will not be sent along with the Excel Sheet.
A Shortcut Key can also be assigned to the Recorded Macro. Press "s" to assign CTRL + s OR Press "S" to assign CTRL + SHIFT + S
REAL LIFE EXAMPLES: These examples will show you how to record and Modify a Macro.
- Printer-friendly version
- Login to post comments
KYXpHkPoEew
health insurance =( life insurance quotes %-D auto insurance rates 413 life insurance for seniors 81984 home insurance florida rhmj
bDRsWtTJtL
LrHHK2 mjhpidzkqnxm, [url=http://gpeaszbtzsrv.com/]gpeaszbtzsrv[/url], [link=http://dzwwrphkkohx.com/]dzwwrphkkohx[/link], http://dgimqghtiife.com/