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

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.

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

--
http://www.standards.com/; See Howard Kaikow's web site.
"dant" <[email protected]> wrote in message
news:[email protected]...
> 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.

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

Additional information:

http://www.cpearson.com/excel/events.htm
Chip Pearson's overview page on events.
--
Regards,
Tom Ogilvy

"dant" <[email protected]> wrote in message
news:[email protected]...
> 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.