Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook and Standard Module
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook and Standard Module
Hi
the workbook and the worksheet modules are used for event procedures. Good starting points explaining this a http://www.cpearson.com/excel/events.htm http://www.mvps.org/dmcritchie/excel/event.htm -- Regards Frank Kabel Frankfurt, Germany wiseman wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook and Standard Module
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook and Standard Module
Frank,
Thank you these web pages explained it well. Barbara. "Frank Kabel" wrote in message ... Hi the workbook and the worksheet modules are used for event procedures. Good starting points explaining this a http://www.cpearson.com/excel/events.htm http://www.mvps.org/dmcritchie/excel/event.htm -- Regards Frank Kabel Frankfurt, Germany wiseman wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to standard module | Excel Discussion (Misc queries) | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) | |||
How to pass values from a userform to a standard module? | Excel Programming | |||
Renaming a standard module | Excel Programming | |||
Inserting Module into Workbook | Excel Programming |