UserForm doesn't show?

[Charlotte E.]

Why doesn't this work:

Dim MyUF As UserForm
Set MyUF = UserForm1
MyUF.Show

???


How to set a userform as a variable???


CE

 

[GS]

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?

 

[Charlotte E.]

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:

 

[GS]

Charlotte E. explained :

Thanks

I need my macro to open different userforms on different conditions, and then
perform some actions on them - much easier this way...

CE

You're welcome!

Depending on the situation.., I use a single userform that changes
according to context via setting the Visible property of frames. I
prefer this to having multiple userforms that only add unnecessary
size/overhead to projects. All frames are managed via a 'ShowPage'
procedure that resets things to the context of the current AppMode
setting.