ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   variables (https://www.excelbanter.com/excel-programming/279709-variables.html)

jim c.

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

Tom Ogilvy

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





All times are GMT +1. The time now is 08:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com