Starting a userform upon starting the file

F

Fritznel

I need to know how to have a userform pop up as the file
is opened. Is there a way to do this?
Thanks,
Fritz
 
H

Heiko

Type your Code inside the Open-Event of the Workbook:

Private Sub Workbook_Open()
<NameofTheUserForm>.Show
End Sub

Heiko
:)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
ASK Field Formatting 1
merging workbooks with userforms 1
Determine if a userform is visible 6
Avoid compile error if userform doesn't exists??? 1
closing another file by code causes failure to run workbook activate event 2
Custom pop-up menus? 2
VBA Code== Goto a webpage using a command button in a UserForm 14

Top