excel crashes on exit since adding a form.

[Peter Bailey]

I have a simple form with two drop down boxes and the user selects from the
list.

the form is opened here:

Private Sub Workbook_Open()
FrmGetInitialData.Show
End Sub

and initialised here and given its conncetion to two cells in the worksheet
here:

Private Sub UserForm_Initialize()
Me.CBCentre.ControlSource = "AuditChecklist!c4"
Me.CBStaffName.ControlSource = "AuditChecklist!P4"
End Sub

and closed here:
Private Sub BtnOK_Click()
Me.Hide
End Sub

it puts the data from the drop down boxes into the cells perfectly but when
I save the spreadsheet it causes an error and wants to send an error report
to microsoft.

can you guys see anything obvious here?

regards in advance

Peter

 

[mangesh_yadav]

The problem is that you don't close the form but hide it. Use
Unload FrmGetInitialData
instead of
FrmGetInitialData.hide or Me.hide

- Manges