This won't work?

Sub ClearOptButChBx()

Dim usf As UserForm
Dim OLEObj As OLEObject

Set usf = ActiveUserForm

For Each OLEObj In usf.OLEObjects
If TypeOf OLEObj.Object Is MSForms.CheckBox Or TypeOf OLEObj.Object
Is MSForms.OptionButton Then
OLEObj.Object.Value = False
End If
Next OLEObj

End Sub


--
Thanks
Shawn


"Shawn" wrote:

I have a file that uses several userforms. These userforms have several
option buttons and check boxes on each.


During "UserForm_Activate()" what code will clear all option buttons and
check boxes at once?

--
Thanks
Shawn