View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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.