Results 1 to 15 of 15

If/Then Checked Boxes

Threaded View

  1. #1
    Registered User
    Join Date
    09-08-2017
    Location
    United States
    MS-Off Ver
    2013
    Posts
    15

    If/Then Checked Boxes

    Hello,

    I am trying to set up my spreadsheet so if you check a box it will change if you can or can not click on other boxes on the sheet. For example, if you go on Amazon and search for computers, you can change what becomes available based on if you check a specific brand or screen size it will then make the next set of boxes you can check available only if the options from your previous choice match the next ones. I am trying to use an if/then set-up in order to say something like: if the box in C11 is checked, don't make the boxes in C13, C14, and C15 able to be checked.

    Another way I was thinking of doing it would be to have the boxes turn either red or green after another one has been checked based on if I want them to be available to be chosen.

    Thanks!
    Last edited by Schmidiot; 09-08-2017 at 08:00 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sumer checked boxes
    By magic2finger in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-02-2017, 08:39 AM
  2. [SOLVED] Average using Checked Boxes
    By syedawab in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-26-2016, 02:54 PM
  3. [SOLVED] How to Count Check Boxes and count the total number of boxes checked
    By t04904 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-12-2013, 11:45 AM
  4. If then Statements & checked Boxes
    By c7015 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-15-2012, 02:00 PM
  5. Check boxes checked
    By EGR2317 in forum Excel General
    Replies: 5
    Last Post: 06-04-2010, 02:27 PM
  6. how to do summation of checked boxes?
    By kaisin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-17-2007, 09:25 PM
  7. How do I total a series of checked boxes?
    By dayoungblood in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-16-2006, 12:40 PM

Tags for this Thread

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