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.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc