+ Reply to Thread
Results 1 to 5 of 5

Forms Check/Uncheck CheckBoxes

  1. #1
    Registered User
    Join Date
    07-05-2006
    Posts
    59

    Forms Check/Uncheck CheckBoxes

    I have a form that has multiple checkboxes and would like to set a button to check all and a button to uncheck all. I have searched and managed to come up with this (which I think is on the edge of being correct):

    Please Login or Register  to view this content.
    Where am I going wrong?

    Just in case the information is necessary the form I am using is named frmFields and the CheckBoxes are named chbx11 through chbx30 (there are 20 of them).

  2. #2
    Registered User
    Join Date
    08-20-2008
    Location
    Philippines
    MS-Off Ver
    Office 2007
    Posts
    18
    How about these?


    Please Login or Register  to view this content.
    Last edited by elcaris; 08-26-2008 at 01:14 PM.

  3. #3
    Registered User
    Join Date
    07-05-2006
    Posts
    59
    I'm getting Run-time error '438'

    Object doesn't support this property or method.

  4. #4
    Registered User
    Join Date
    08-20-2008
    Location
    Philippines
    MS-Off Ver
    Office 2007
    Posts
    18
    I think I forgot to consider other controls in your form...

    Lets try this code...

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    07-05-2006
    Posts
    59
    Okay, from another thread where I asked a similar question I managed to come up with the following (and it works):

    Please Login or Register  to view this content.
    I actually got this before I saw your most recent post; however, your post did jog my memory so I do appreciate it. I do have another question though:

    What is the difference in what I found as opposed to what you recently posted? Is one better than the other?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Hiding columns that have forms control checkboxes
    By rgarber1950 in forum Excel General
    Replies: 1
    Last Post: 11-17-2007, 11:17 AM
  2. Problems filtering data containing checkboxes???
    By nameyers in forum Excel General
    Replies: 1
    Last Post: 10-18-2007, 02:48 PM
  3. Copy Forms (combo boxes & checkboxes) down many cells & auto. increment cell links
    By tones321 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2007, 12:52 PM
  4. Check/Uncheck all checkboxes
    By JChandler22 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-23-2007, 03:03 PM
  5. Checkboxes and filters
    By penny in forum Excel General
    Replies: 1
    Last Post: 03-26-2007, 09:27 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1