Friday, July 31, 2009

Get Started

Hi there its me again,
I will now tell you how to start with the basic commands to create macros.

Step 1 : open an empty worksheet.
step 2: press "Alt+F11" or (Tools-->Macro --> visual basic editor)
step 3: In the VB editor select Insert--> Module
step 4: this is your interface where we can start writing codes (known as a macro).
step 5: the macro should have " Sub () " in the beginning and "End Sub" in the end.
this is how a basic structure of macro is created.
to run the macro you eith press "F5" or "Run" Button on the editor.

In next Tip I will talk about creating a small button on the spreadsheet itself and asscoiate it with the written macro.

No comments:

Post a Comment