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

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