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
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