How do you display a VBA user form when starting excel workbook?

[dant]

How do you display a VBA user form when starting excel workbook? Code works
to populate a list box based on choice in previous list box but how do you
show the form so that it can be used when you start excel? I want to make it
an excel form to collect data that has interdependanrt fields.

 

[Howard Kaikow]

1 way is to start the userform from an autoopen macro.

 

[MBlake]

Open your VBE window (Alt+F11)
Ensure your Project Window is open (View - Project Explorer)
Click on the 'This Workbook' for your Excel file

Add code but substitute MyForm for the name of your userform.

' Opens userform at startup
'
Private Sub Workbook_Open()
frmMyForm.Show
End Sub

Regards,
Mickey

 

[Tom Ogilvy]

Additional information:

http://www.cpearson.com/excel/events.htm
Chip Pearson's overview page on events.