Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2006

Tip: Looking for answers? Try searching our database.

Can a user form be opened from a macro??

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mike703 - 06 Jul 2006 20:34 GMT
Hi All,

I have a macro that will format project files based on their projec
number. in order to record the prject number. I have created a form fo
the user to enter the project number. My problem is entering a comman
line to open the form once the user selects which type of project fil
is to be formatted (a popup window first displays in the macro).
would like for the user form to popup if the correct button is clicke
on the original popup window. How?
Bob Phillips - 06 Jul 2006 21:25 GMT
Userform1.Show

or do you mean something else?

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Hi All,
>
[quoted text clipped - 5 lines]
> would like for the user form to popup if the correct button is clicked
> on the original popup window. How??

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.