Link to home
Start Free TrialLog in
Avatar of andy7789
andy7789

asked on

VBA: how to reset checkboxes inside a frame

Hi x-perts,

is there a way to reset ALL checkboxes inside of a frame?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of RobSampson
RobSampson
Flag of Australia image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of andy7789
andy7789

ASKER

Thanks, Rob,

none of your versions worked, but this is a slightly modified one that makes its job:

Cheers,

Andy
For Each objControl In Me.Frame2.Controls
    If TypeName(objControl) = "CheckBox" Then
       objControl.Value = 0
   End If
Next objControl

Open in new window

Avatar of RobSampson
RobSampson
Flag of Australia image
Oh yeah, typo in my option 2....sorry about that.

Thanks for the grade.

Regards,

Rob.