How to clear all checkboxes on a form?
in [Functions]
|
Prev: Referencing a cell in other worksheet that is using autofit ro
Next: Using external query (mdb) for dynamic date range
From: Arlen on 5 May 2010 17:44 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
From: Bob Phillips on 5 May 2010 19:09 For Each ctl In Me.Controls If TypeName(ctl) = "CheckBox" Then ctl.Value = False End I Next ctl -- HTH Bob "Arlen" <Arlen(a)discussions.microsoft.com> wrote in message news:700CD724-30FB-4D93-AF50-451FB6585027(a)microsoft.com... > 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
From: Arlen on 6 May 2010 11:20
Thanks, Bob! "Bob Phillips" wrote: > For Each ctl In Me.Controls > > If TypeName(ctl) = "CheckBox" Then > > ctl.Value = False > End I > Next ctl > > -- > > HTH > > Bob > > "Arlen" <Arlen(a)discussions.microsoft.com> wrote in message > news:700CD724-30FB-4D93-AF50-451FB6585027(a)microsoft.com... > > 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 > > > . > |