UserForm doesn't show?
Thanks :-)
I need my macro to open different userforms on different conditions, and
then perform some actions on them - much easier this way...
CE
Den 11.10.2011 04:49, GS skrev:
Charlotte E. explained :
Why doesn't this work:
Dim MyUF As UserForm
Set MyUF = UserForm1
MyUF.Show
???
How to set a userform as a variable???
CE
A UserForm doesn't have a Show method (according to the ObjectLib).
An Object Set to a UserForm does have a Show method.
Example:
Dim MyUF As Object
Set MyUF = UserForm1
MyUF.Show
However, why not just...
UserForm1.Show
...so you don't have the overhead of storing a ref to it in a variable?
|