PC Review


Reply
Thread Tools Rate Thread

How to clear all checkboxes on a form?

 
 
Arlen
Guest
Posts: n/a
 
      5th May 2010
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
 
Reply With Quote
 
 
 
 
Bob Phillips
Guest
Posts: n/a
 
      6th May 2010
For Each ctl In Me.Controls

If TypeName(ctl) = "CheckBox" Then

ctl.Value = False
End I
Next ctl

--

HTH

Bob

"Arlen" <(E-Mail Removed)> wrote in message
news:700CD724-30FB-4D93-AF50-(E-Mail Removed)...
> 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



 
Reply With Quote
 
Arlen
Guest
Posts: n/a
 
      6th May 2010
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" <(E-Mail Removed)> wrote in message
> news:700CD724-30FB-4D93-AF50-(E-Mail Removed)...
> > 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

>
>
> .
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Clear certain checkboxes Arlen Microsoft Excel Misc 4 20th May 2010 11:42 PM
Clear Form's textboxes and checkboxes??? TotallyConfused Microsoft Access VBA Modules 1 15th Sep 2009 01:10 AM
Clear All Checkboxes? =?Utf-8?B?QnJhZA==?= Microsoft Excel Programming 3 11th Jan 2005 07:58 PM
VBA to clear all CheckBoxes? newboy18 Microsoft Excel Programming 3 30th Mar 2004 11:37 PM
Clear checkboxes =?Utf-8?B?SmFpbWUgQW5kZXJzZW4=?= Microsoft Excel Worksheet Functions 1 30th Dec 2003 07:29 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:26 PM.