Display form in an excel worksheet without clicking a butoon

[Richard Flame]

Hi everyone,

Is it possible to display a userform once the workbook is open. I don't want to have a button that I can click to display the form. I want it to pop up by itself. Thanks in advance

[jasoncw]

Sure, just activate the userform in the Workbook_Open event handler procedure.

Jason

[jasoncw]

Richard, in case that was not clear, copy the following code into the ThisWorkbook module of your file:

Private Sub Workbook_Open()
    UserForm1.Show
End Sub

Change UserForm1 to the name of your user form.

HTH

Jason

[Richard Flame]

Jason,

Thank you ! That's what I exactly wanted.

[jasoncw]

Glad I could help you out, Richard.