Code in under Sheets or Under Module... That is the question

[mtheriault2000]

Hello

An interogation form me

When should i place my VBA code under a Sheets or when should I place it under a Module

Does it make a difference?

Martin

 

[Norie]

Martin

Really depends what the code is meant to do and how you want to have it run.

 

[mtheriault2000]

Hello Norie

It as been a while....

Code are macro to be executed when call by a click on textbox or drawing in my sheets. I don't use Excel form coding.

Actually, I got macro code i both.
Why? I just started to code in Sheets then I created a new macro that as been placed under a Module

And it started my interogation ???? Did look around, but did not found a link for a good explanation.

Have a great day under your sun

Martin
Montreal, Canada