+ Reply to Thread
Results 1 to 2 of 2

Make Check Boxes Un-Checkable

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

    Make Check Boxes Un-Checkable

    I would like to create a macro that makes it so if I check a checkbox in excel I can set it up so other boxes are not able to be checked (I am trying to disable the other boxes) once that one has been selected. I am currently using this code that someone helped me with before to make the boxes turn red:

    Please Login or Register  to view this content.
    This code works but I have been asked to see if I can get the boxes to be un-checkable instead of just having them change color. If anyone has any advice on how to do this, it would be greatly appreciated.

    Thank you!
    Last edited by Schmidiot; 09-21-2017 at 06:17 AM.

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

    Re: Make Check Boxes Un-Checkable

    Turns out I had an error elsewhere in my code and the code above does make the checkboxes disabled.

+ 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. Make changes to check boxes
    By Ekova in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-07-2015, 05:26 PM
  2. Check boxes that delete other check boxes and change the color of another cell.
    By nhamhamilton in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-29-2014, 02:40 PM
  3. [SOLVED] Coding Yes/No option buttons to not allow check boxes or require check boxes
    By HeyInKy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2014, 11:32 PM
  4. Replies: 0
    Last Post: 06-27-2014, 04:16 PM
  5. I need a code for presence check to check multiple text boxes and combo boxes
    By Lee_wwfc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-24-2013, 01:53 PM
  6. [SOLVED] Make all check boxes = true
    By azland00123 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-26-2012, 11:41 AM
  7. Make Check Boxes behave as Option buttons
    By nikolab in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-29-2009, 06:48 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