Workbook and Standard Module

[wiseman]

I have not done any programming, just recorded macros and copied bits of
code from web pages, so please excuse the dumb question, but I have done
searches in Excel help, google groups and not found the answer.

I recently saw a useful looking piece of code, but it was supposed to be put
the in your workbook module (not in a standard
module). Could someone explain in a fairly simply way what the difference
is.

Thanks,
Barbara

 

[Frank Kabel]

Hi
the workbook and the worksheet modules are used for event procedures.
Good starting points explaining this are:
http://www.cpearson.com/excel/events.htm
http://www.mvps.org/dmcritchie/excel/event.htm

 

[Guest]

You may also want to do some research on Scope of variables and procedures. Standard modules are meant for user defined Functions, Subs and Variables that are to be project wide, to be called from other procedures.

----- wiseman wrote: ----

I have not done any programming, just recorded macros and copied bits o
code from web pages, so please excuse the dumb question, but I have don
searches in Excel help, google groups and not found the answer

I recently saw a useful looking piece of code, but it was supposed to be pu
the in your workbook module (not in a standar
module). Could someone explain in a fairly simply way what the differenc
is

Thanks
Barbar

 

[wiseman]

Frank,
Thank you these web pages explained it well.
Barbara.