How to make a user form appear when a workb

Solved/Closed
Report
Posts
29
Registration date
Saturday August 7, 2010
Status
Member
Last seen
August 31, 2010
-
Posts
29
Registration date
Saturday August 7, 2010
Status
Member
Last seen
August 31, 2010
-
Hello,....

I need a user form to appear when i open a workbook.. I dont want to run it in macro need it to automatically appear once the workbook is opened.

Thanks...

2 replies


Dear Sarc,

Please provide more information about the problem you are experiencing.

Thanks in advance.
0
Posts
29
Registration date
Saturday August 7, 2010
Status
Member
Last seen
August 31, 2010

Thanks wyaat,...

I found the solution..I was looking for something like this,.

Private Sub Workbook_Open()

    UserForm1.Show

End Sub


Thanks...
0