Hi Kevin

You can use a event to open the userform

Read Chip Pearson's site about Events
http://www.cpearson.com/excel/events.htm

Copy this in the thisworkbook module

Private Sub Workbook_Open()
userform1.Show
End Sub

See also
How to use Visual Basic for Applications examples to control UserForms in Microsoft Excel
http://support.microsoft.com/default...b;EN-US;829070


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kevin" wrote in message ...
How do I open a form using VBA in Excel XP? Help is of
little help? I want to load the form on startup of the
workbook.

TIA

Kevin