| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set objects at module level?
Hi Ed,
So if I'm doing a lot of Subs in THisWorkbook module, I can DIm and Set objects in a Workbook_Open sub and they will live in that module as long as the workbook is open? Exactly. As long as you don't press "End" on a runtime error... Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assign Value to Module Level Variable | Excel Programming | |||
| use of module level variables | Excel Programming | |||
| Declaring array constants at module level | Excel Programming | |||
| referencing at module level | Excel Programming | |||
| module-level variable lifetime | Excel Programming | |||
Threaded Mode
