Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 146
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Capture Forms button caption Otto Moehrbach Excel Programming 5 November 9th 07 04:46 PM
How to reference win.caption, when caption changes Paul987[_21_] Excel Programming 3 April 7th 06 05:09 PM
Getting Forms button caption Otto Moehrbach Excel Programming 3 September 11th 05 12:11 AM
Change Caption of Forms Command Button No Name Excel Programming 9 December 10th 04 07:59 AM
Calling Forms from Forms - Exit problems Stuart[_5_] Excel Programming 3 May 25th 04 06:50 AM


All times are GMT +1. The time now is 09:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"