VB Code Location; sheet, workbook, module

[James Hamilton]

I'm new to VB. Does it matter whether I put my VB code in the sheet, workbook
or modules on the VB window?

Thanks.

[Anne Troy]

It sure does. You might want to consider taking Lesson1 of Excel VBA
Training at http://www.vbaexpress.com/training/

In a nutshell:
Put it in a module if you're unsure.
Anything that you want to occur on a specific worksheet as a result of a
specific action, put in the worksheet code.
Anything that you want to occur in the workbook, such as before you close it
or save it or when you open it, then the code should go in ThisWorkbook.
Well, there's class modules too. I know Chip Pearson has some good info
about it. Though it says Excel 97, things haven't changed a whole heckuva
lot:
http://www.cpearson.com/excel/events.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com



"James Hamilton" <[email protected]> wrote in message
news:[email protected]...
> I'm new to VB. Does it matter whether I put my VB code in the sheet,
workbook
> or modules on the VB window?
>
> Thanks.

[James Hamilton]

Many thanks Anne.

"Anne Troy" wrote:

> It sure does. You might want to consider taking Lesson1 of Excel VBA
> Training at http://www.vbaexpress.com/training/
>
> In a nutshell:
> Put it in a module if you're unsure.
> Anything that you want to occur on a specific worksheet as a result of a
> specific action, put in the worksheet code.
> Anything that you want to occur in the workbook, such as before you close it
> or save it or when you open it, then the code should go in ThisWorkbook.
> Well, there's class modules too. I know Chip Pearson has some good info
> about it. Though it says Excel 97, things haven't changed a whole heckuva
> lot:
> http://www.cpearson.com/excel/events.htm
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
> www.MyExpertsOnline.com
>
>
>
> "James Hamilton" <[email protected]> wrote in message
> news:[email protected]...
> > I'm new to VB. Does it matter whether I put my VB code in the sheet,
> workbook
> > or modules on the VB window?
> >
> > Thanks.
>
>
>