| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
variables
I have about 50 variables that when a user clicks a reset
button all the variables are set to their original state. example: a = False b = "" c = 0 d = Nothing this group of variables accounts for every module level variable. My question is, is there an easier way to reset these variables with some type of for next loop or procedure/method that could accomplish this without having them all coded as above? TIA |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
variables
No. Not a good way. You could issue an END statement but that stops code
execution as well. Regards, Tom Ogilvy "jim c." wrote in message ... I have about 50 variables that when a user clicks a reset button all the variables are set to their original state. example: a = False b = "" c = 0 d = Nothing this group of variables accounts for every module level variable. My question is, is there an easier way to reset these variables with some type of for next loop or procedure/method that could accomplish this without having them all coded as above? TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum if 2 variables | Excel Discussion (Misc queries) | |||
| Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
| How do I add variables | Excel Discussion (Misc queries) | |||
| Variables in VBA | Excel Discussion (Misc queries) | |||
| SUM IF and two variables | Excel Worksheet Functions | |||
Linear Mode
