Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
set variable once
is it possible to set a variable just once and have many subs use it?
example: user = sheets("1").range("a1") 'i would like to have this set only once at top of module sheet sub temp1() msgbox user 'i would like for this and many other subs to know what 'user' is end sub i know i can define 'user' in a sub, then use sub temp1(user), but i would rather not since there will be so many subs w/ 'user' needed. thanks, mike allen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Runtime Error '91' Object variable or With block variable not set | Excel Discussion (Misc queries) | |||
variable height variable width stacked bar charts | Charts and Charting in Excel | |||
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 | |||
setting a range variable equal to the value of a string variable | Excel Programming | |||
Cells.Find error Object variable or With block variable not set | Excel Programming |