craig.penny
Well-known Member
- Joined
- May 8, 2009
- Messages
- 656
Hi all,
I have a string variable which I have succesfully passed to a sub in a userform. The variable is used to call a second userform from the one it was passed into. My problem is that I have no idea how to execute the %^&$ thing.
Suppose I have a variable
MyVar = "MyName"
which has been passed into a userform sub (keeping the same variable name, that is, it is also called MyVar in the sub's parameter list). Now I want to use it to show a userform that is named "MyName", which has already been loaded.
MyVar.show doesn't work and I can't figure out how I might use CallByName to accomplish this.
Please help, my head's getting soft!![Eek! :eek: :eek:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I have a string variable which I have succesfully passed to a sub in a userform. The variable is used to call a second userform from the one it was passed into. My problem is that I have no idea how to execute the %^&$ thing.
Suppose I have a variable
MyVar = "MyName"
which has been passed into a userform sub (keeping the same variable name, that is, it is also called MyVar in the sub's parameter list). Now I want to use it to show a userform that is named "MyName", which has already been loaded.
MyVar.show doesn't work and I can't figure out how I might use CallByName to accomplish this.
Please help, my head's getting soft!