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?

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?

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

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