Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Displaying a user form automatically in excel

Posted on 2003-02-20
2
Medium Priority
?
233 Views
Last Modified: 2010-04-17
Is it possible when I open my applicatin in excel using vba I can get it to automatically display a user form? i.e. initially display a splash screen which will then display a main menu for the system.  In the visual basic editor window if I wish to run the user forms I have to press play and even when i do that it asks me what macros id like to run, however all my macros are invoked within subs.

Thanks,
Natalie
0
Comment
Question by:NatalieVance
2 Comments
 
LVL 14

Accepted Solution

by:
Tommy Kinard earned 60 total points
ID: 7989705
Private Sub Workbook_Open()
UserForm1.Show
End Sub
0
 

Author Comment

by:NatalieVance
ID: 7992647
Spot On!! Thankyou DragonTooth
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Make the most of your online learning experience.
Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
Screencast - Getting to Know the Pipeline

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question