Default Startup Form 1

[drkestrel]

I have created a form in Excel VBA within an Excel Workbook test.xls. How could I set test.xls such that the form I created frmTest get displayed automatically when test.xls is opened?

 

[DarkSun]

Place this bit of code in the ThisWorkbook Code screen in VB editor.

Private Sub Workbook_Open()
FrmTest.Show
End Sub

 

[Kaah]

or even:

Sub auto_open()
frmtest.show
end sub

in any seperate module you choose....

K.