PC Review


Reply
Thread Tools Rate Thread

Calling Forms by their Caption?

 
 
NateBuckley
Guest
Posts: n/a
 
      20th Mar 2008
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 With Quote
 
 
 
 
Chip Pearson
Guest
Posts: n/a
 
      20th Mar 2008
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" <(E-Mail Removed)> wrote in message
news:CC9381AA-3A5C-4CB2-84A7-(E-Mail Removed)...
> 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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Startup and forms caption lmv Microsoft Access 2 14th May 2008 01:25 PM
Getting Forms button caption Otto Moehrbach Microsoft Excel Programming 3 11th Sep 2005 12:11 AM
Caption item within forms =?Utf-8?B?UGF0cmljayBTdHViYmlu?= Microsoft Access Forms 1 21st Jun 2005 01:41 AM
Calling Forms from Forms - Exit problems Stuart Microsoft Excel Programming 3 25th May 2004 06:50 AM
sub forms caption property Ayala Microsoft Access Form Coding 2 4th Dec 2003 06:35 AM


Features
 

Advertising
 

Newsgroups
 


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