Unable to load UserForm on Excel Startup

Does anyone know how to load a UserForm in the Workbook_Open subprocedure of an Excel Application?
efarhatAsked:
Who is Participating?
 
aelatikConnect With a Mentor Commented:
Private Sub Workbook_Open()
    UserForm1.Show
End Sub
0
 
efarhatAuthor Commented:
should it be modeless?
0
 
efarhatAuthor Commented:
also, on my command buttons.. i thought if you add "%Caption" it will make the "C" a shortcut?
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
domjCommented:
"&Caption" will make it a shortcut.
0
 
aelatikCommented:
should it be modeless? >>>>

That is something you need to decide, if you want the user to be able to edit while the form is running then use Model otherwise not
0
 
efarhatAuthor Commented:
& doesn't work in Excel. is it a bug?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.