Solved: VBA userform

[anandbw82]

Hi All,

I have created on userform in VBA. I want it to be activated when i open the workbook.
I mean whenever i open that workbook that form should appear.

Please give me the solution and i will give appreciation..

Thanks in advance

[georgiboy]

In the ThisWorkbook window in the VBE paste this...

[VBA]Private Sub Workbook_Open()

UserForm1.Show

End Sub[/VBA]

Assuming your userform is called UserForm1.

Hope this helps

[anandbw82]

It works.

Thank you very much.

[mdmackillop]

If you need to be able to work in the Spreadsheet with the form on the screen, then open it non-modal

[vba] .
UserForm1.Show False

[/vba]