| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to declare global variable in Excel VBA?
Dear Excel Gurus,
This may sound like a basic question, but I only know C and am new to Excel VBA I wish to define a global variable that is accessible to all worksheets. Can someone advise? Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to declare global variable in Excel VBA?
In a standard/regular module - not a Class module - at the top of the module... Public Const LNG_LENGTH As Long = 123 -or- Public lngLength as Long -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Sing" wrote in message Dear Excel Gurus, This may sound like a basic question, but I only know C and am new to Excel VBA I wish to define a global variable that is accessible to all worksheets. Can someone advise? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Global Variable in Excel VBA | Excel Programming | |||
| Global array declare | Excel Programming | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
| Global Variable -- Excel / VBA | Excel Discussion (Misc queries) | |||
| How to declare variable as Excel constant? | Excel Programming | |||
Linear Mode
