Display an Userform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

How can I display an userform every time I open my workbook ?
Jeff
 
Hi Jeff

place this code in the Workbook_Open procedure of the ThisWorkbook module

userform1.show

Please feel free to post back if you require more detailed instructions.

Cheers
JulieD
 
Put it in the ThisWorkbook module within the Workbook_open event

userform1.show
 
Hi,
Where is the Workbook_Open procedure ?
Jeff


JulieD said:
Hi Jeff

place this code in the Workbook_Open procedure of the ThisWorkbook module

userform1.show

Please feel free to post back if you require more detailed instructions.

Cheers
JulieD
Click to expand...
 
Hi Jeff

if the VBE window, you will see Sheet1, Sheet2, Sheet3 etc above the
userform that you created, you should also see ThisWorkbook
double click on ThisWorkbook and then on the right hand side, choose
Workbook from the top left hand drop down - this will create the
Workbook_Open procedure for you

Let us know how you go
Cheers
JulieD
 
You must log in or register to reply here.

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

Excel Excel 2007 fails on insert userform 0
Minimize button on userform? 3
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Excel Displaying content from excel sheet onto textbox in userform 0
Custom User Form At Startup 1
Access Dateadd function question.. 0
Printing UserForms 1
Refresh Userform 1

Back
Top