+ Reply to Thread
Results 1 to 3 of 3

Using Checkboxes to Select Other Checkboxes

  1. #1
    Registered User
    Join Date
    07-12-2014
    Location
    Chicago
    MS-Off Ver
    2013
    Posts
    67

    Using Checkboxes to Select Other Checkboxes

    I created a userform that has checkboxes arranged like this:

    []All Days []Weekdays Only []Other

    []Monday []Friday
    []Tuesday []Saturday
    []Wednesday []Sunday
    []Thursday

    And a command button.

    What I want is to be able to:
    -Click "All Days" and all of the days be selected
    -Click "Weekdays Only" and only have "Monday"-"Friday" selected
    -"Other" Turns all other boxes to "False"
    -If you manually turn all days to "True", then "All days" is automatically set to "True"
    -If you manually turn Monday - Friday to "True", then "Weekdays Only" is automatically set to "True"
    -If you choose any other configuration of days, then "Other" is automatically set to "True"

    Thanks!
    -Andrew

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Using Checkboxes to Select Other Checkboxes

    Andrew

    How have you named the checkboxes?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    07-12-2014
    Location
    Chicago
    MS-Off Ver
    2013
    Posts
    67

    Re: Using Checkboxes to Select Other Checkboxes

    cbAllDays
    cbWeekdaysOnly
    cbOther
    cbMonday
    cbTuesday
    cbWednesday
    cbThursday
    cbFriday
    cbSaturday
    cbSunday

    Thanks!

+ 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. Replies: 4
    Last Post: 04-28-2013, 12:47 AM
  2. Print Sheets based on checkboxes in UserForm, Checkboxes also control another macro
    By krackaberr in forum Excel Programming / VBA / Macros
    Replies: 34
    Last Post: 03-05-2013, 11:12 AM
  3. VBA code to select All checkboxes
    By itsmenick in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-19-2012, 05:57 PM
  4. CheckBoxes using Select Case
    By Blondegirl in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-25-2007, 09:10 AM
  5. How to select checkBoxes as a group in
    By Fendic in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2005, 10:05 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