Calling Forms by their Caption?
 

Is it possible to go through all the user forms and only load up the one with
the name I want.

So If I had a form called "frmMain" and a ton of others, would it be
possible (before loading the form) to go through these forms and use a string
"frmMain" to load it up?

Thanks in advance. Hopefully that was clear enough.

Calling Forms by their Caption?
 

See http://www.cpearson.com/Excel/ShowAnyForm.htm for code to do this.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




"NateBuckley" wrote in message
...
Is it possible to go through all the user forms and only load up the one
with
the name I want.

So If I had a form called "frmMain" and a ton of others, would it be
possible (before loading the form) to go through these forms and use a
string
"frmMain" to load it up?

Thanks in advance. Hopefully that was clear enough.