I wish to take help by using Macro in MS Excel. But dont know how to use. As I click 'Macro' from tool option there my confusion begin. As to where do I write code?
- in macro (which ask 1st macro name & then a blank window)
- or in Visual Basic option
In Visual Basic window... there are lot of sublist for worksheets & workbook.
So, which one I going to choose for simplyfy my job in excel. Is there any free e-book availble for us (beginner).
Last edited by VBA Noob; 11-23-2007 at 03:56 AM.
Good morning niharika
OK. First open Excel with just one file open (say test.xls).
Press Alt + F11, this will open the VBE (Visual Basic Environment).
In the Project window (left hand side) click on your file (test.xls).
Then go to Insert > Module.
Paste the code you've got (my module?) into the big blank window that opens.
Go to File > Close and Return to Microsoft Excel.
When you save the file, the Macro will be saved with it.
To run the macro go to Tools > Macro > Macros, select the name of the module and click Run.
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
you should first start recording a macro while you play with the excel, to see how the VBA coding works.
then follow the steps dominic wrote to read the code and start understanding it.
its a long run, dont try to understand some complicated codes right in the beggining.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks