View Single Post
  #3   Report Post  
Chip Pearson
 
Posts: n/a
Default

You probably want

Call Userform_Initialize

rather than

Call frmDataEntry_Initialize


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"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