Calling Forms by their Caption?

[NateBuckley]

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.

 

[Chip Pearson]

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)