using string to call a userform

[craig.penny]

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!

 

[NateO]

Hello,

See the following:

http://support.microsoft.com/kb/157609

 

[craig.penny]

NateO,

You.Are.The.MAN!

Thank you!

 

[NateO]

You are welcome.

Edit: Sorry about your Tigers.

 

[craig.penny]

Yep. Me too.