View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
Default How to clear all checkboxes on a form?

For Each ctl In Me.Controls

If TypeName(ctl) = "CheckBox" Then

ctl.Value = False
End I
Next ctl

--

HTH

Bob

"Arlen" wrote in message
...
That's it. How is it possible to create push-button functionality that
resets all checkboxes to empty?

Also, is it possible that pushing a button could increase a counter, or
light up a first, second and third cell, that would then be reset by the
button I asked for above?

I thank you for your time.

Arlen