Proper way to create new macro

[Simon]

I hit record then immediate after I hit stop then, step in and type in
code.

When is the best way?

 

[Joel]

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]

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.






- Show quoted text -

Hi Joel,

So in Excel you hit Alt F11 then click Insert Module?

Regards

Simon

 

[Joel]

Yes, or go to worksheet menu Tools - Macro - Visual Basic Editor.