Hi Kobus,

You can wite the code in the Open event of workbook to show the form

Private Sub Workbook_Open()
Userform1.Show
End Sub

Thanks
Xcelion


"Kobus" wrote:

Using VBA in Excel, how do I display the first UserForm immediate when the
workbook has opened. The UserForm prompts the user for a date and then
recalculates all the values in the worksheet according to the date.