How to open VBA form automatically when worksheet is opened

[anitshekhar]

I have created form using VB Editor in Excel. I wanted to open it automatically when the worksheet is open. Can anybody help me in this regard.

Example
Worksheet name : bank.xls
Form name : bankform

Thanks

 

[SkipVought]

Hi,

In the Workbook_Open event

Private Sub Workbook_Open()
    bankform.show

Hope this helps

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com