Hi All,
I have a userform that, when completed, will generate about 16 variables. The variables are named the same except that each one has a different number as the last character.
When the form is closed it calls a procedure that acts based upon changes to these variables (mostly Boolean). The procedure checks a range of values, with a Do Loop, and then makes changes accordingly. There does not seem to be any way to use the same Do Loop by changing the variable name with a wild card. Do I have build a whole series of Do Loops, or can I use one and change the variables with a wild card somehow?
Thank you
David
I have a userform that, when completed, will generate about 16 variables. The variables are named the same except that each one has a different number as the last character.
When the form is closed it calls a procedure that acts based upon changes to these variables (mostly Boolean). The procedure checks a range of values, with a Do Loop, and then makes changes accordingly. There does not seem to be any way to use the same Do Loop by changing the variable name with a wild card. Do I have build a whole series of Do Loops, or can I use one and change the variables with a wild card somehow?
Thank you
David