UserForms: Clear all Option Buttons

[Shawn]

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?

 

[Shawn]

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

 

[Shawn]

Instead of setting the userform to "hide" I "unload" it. That seems to do
the trick.