How to make a user form appear when a workb

Solved/Closed
SARC Posts 29 Registration date Saturday August 7, 2010 Status Member Last seen August 31, 2010 - Aug 16, 2010 at 04:19 AM
SARC Posts 29 Registration date Saturday August 7, 2010 Status Member Last seen August 31, 2010 - Aug 16, 2010 at 05:02 AM
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

Blocked Profile
Aug 16, 2010 at 04:58 AM
Dear Sarc,

Please provide more information about the problem you are experiencing.

Thanks in advance.
0
SARC Posts 29 Registration date Saturday August 7, 2010 Status Member Last seen August 31, 2010
Aug 16, 2010 at 05:02 AM
Thanks wyaat,...

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

Private Sub Workbook_Open()

    UserForm1.Show

End Sub


Thanks...
0