Try using the Command Button with the code like
Private Sub CommandButton1_Click()
ComboBox1 = ""
TextBox1 = ""
End Sub
etc
Regards,
"MBlake" wrote in message
...
Hi,
I have a userform containing various VBA controls such as comboboxes,
listboxes and check boxes. I want to provide the option for a user to
clear the form. I have tried the below code but get an error message
stating 'Compile error - Sub or Function not defined'
Please can anyone tell me where I am going wrong with this?
Command Button Code -
Private Sub cmdbuttonClear_Click()
Call frmDataEntry_Initialize
End Sub
Thanks for any help,
Mickey
|