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 responses

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

Please provide more information about the problem you are experiencing.

Thanks in advance.
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...