| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Proper way to create new macro
I hit record then immediate after I hit stop then, step in and type in
code. When is the best way? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Proper way to create new macro
I just type two lines
Sub Test end Test Most of the time I put the macros in Module sheets so I Have to use the VBA menu to create the Module sheet Insert - Module. You can just type macros into sheets and thisworkbook without inserting a module. "Simon" wrote: I hit record then immediate after I hit stop then, step in and type in code. When is the best way? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Proper way to create new macro
On Aug 1, 12:16*pm, Joel wrote:
I just type two lines Sub Test end Test Most of the time I put the macros in Module sheets so I Have to use the VBA menu to create the Module sheet * * * *Insert - Module. *You can just type macros into sheets and thisworkbook without inserting a module. "Simon" wrote: I hit record then immediate after I hit stop then, step in and type in code. When is the best way?- Hide quoted text - - Show quoted text - Hi Joel, So in Excel you hit Alt F11 then click Insert Module? Regards Simon |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Proper way to create new macro
Yes, or go to worksheet menu Tools - Macro - Visual Basic Editor.
"Simon" wrote: On Aug 1, 12:16 pm, Joel wrote: I just type two lines Sub Test end Test Most of the time I put the macros in Module sheets so I Have to use the VBA menu to create the Module sheet Insert - Module. You can just type macros into sheets and thisworkbook without inserting a module. "Simon" wrote: I hit record then immediate after I hit stop then, step in and type in code. When is the best way?- Hide quoted text - - Show quoted text - Hi Joel, So in Excel you hit Alt F11 then click Insert Module? Regards Simon |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro for Proper function | Excel Worksheet Functions | |||
| a macro to PROPER text | New Users to Excel | |||
| Macro for proper case | Excel Discussion (Misc queries) | |||
| proper way to create a userform | Excel Programming | |||
| macro using PROPER function | Excel Programming | |||
![Simon[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
