Load a Userform

N

Nick

How do I program Excel so that I can automatically load a
userform upon opening a workbook?
 
N

nathan

-----Original Message-----
How do I program Excel so that I can automatically load a
userform upon opening a workbook?
.
In the vb screen under this workbook, select
workbook_open then put in userform1.show, which will load
and show, or just load userform1 to load it, then when
ever you need it userform1.show.

Hope this helps.

Nath.
 

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

Top