Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros
Hi, I want to learn wht is macro & how can we create it so pls. tell me
step by step |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros
The simplest way to begin to learn about macros in excel is to use the
recording function. Go to ToolsMacros record. Do some actions in your worksheet and then stop the recording. When you go into the visual basic editor (ToolsMacrosVB Editor) you will be able to see what excel has written for the actions that you did. Be warned that there will be a lot of extraneous code created by XL, hence any experienced VB guys don't use this. "Vicky" wrote: Hi, I want to learn wht is macro & how can we create it so pls. tell me step by step |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros
I agree with Naomi but make your initial recordings very simple operations,
check the format of the recorded macro and then "play" with changing cell references. I do a lot of my initial macro work by recording some aspect of what I want to do and then reviewing the code which was generated for ideas, Some macros need minimal changes. others end up not looking at all like the recorded macro. "Naomi" wrote: The simplest way to begin to learn about macros in excel is to use the recording function. Go to ToolsMacros record. Do some actions in your worksheet and then stop the recording. When you go into the visual basic editor (ToolsMacrosVB Editor) you will be able to see what excel has written for the actions that you did. Be warned that there will be a lot of extraneous code created by XL, hence any experienced VB guys don't use this. "Vicky" wrote: Hi, I want to learn wht is macro & how can we create it so pls. tell me step by step |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
weird saving of a document with macros resulting with macros being transfered to the copy | Excel Programming | |||
Macros inside macros, and pasting into macro code. | Excel Programming | |||
Open workbook-macros enabled, opening another with macros | Excel Programming | |||
Macro Size Limit / open macros with macros? | Excel Programming | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming |