How to make a user form appear when a workb

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

Please provide more information about the problem you are experiencing.

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

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

Private Sub Workbook_Open()

    UserForm1.Show

End Sub


Thanks...