What code do I use to add a user form to Excel worksheet?
 

I can make a user form with all the bells and whistles, but how can I get it
to load in my excel program when it opens? I have never tried this before.
Thanks

What code do I use to add a user form to Excel worksheet?
 

Hammer

Put code like this in the ThisWorkbook module (Presumes form is called
UserForm1)

Private Sub Workbook_Open()
UserForm1.Show
End Sub


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Hammer1947" wrote in message
...
I can make a user form with all the bells and whistles, but how can I get
it
to load in my excel program when it opens? I have never tried this before.
Thanks