Display an Userform

[Jeff]

Hello,

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

 

[JulieD]

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

 

[Don Guillett]

Put it in the ThisWorkbook module within the Workbook_open event

userform1.show

 

[Jeff]

Hi,
Where is the Workbook_Open procedure ?
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

 

[JulieD]

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

 

[Jeff]

Thank you, it worked.
Jeff

Put it in the ThisWorkbook module within the Workbook_open event

userform1.show

 

[Don Guillett]

glad to help