+ Reply to Thread
Results 1 to 5 of 5

Change check box fill color to unfill and clear check mark

  1. #1
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    Change check box fill color to unfill and clear check mark

    I have this code to only allow one check box is allow to check. But I want to change the
    box fill color and be able to create more groups of check box works in independently in each group.

    Please see attached example for more information.

    In the check boxes, I want to …
    1. Change the gray shade pattern to color fill.
    Example: Light Blue R: 220, G: 230, B: 241
    2. In Group 1, click any box to add check mark and box fill color will change to unfill. (This is the current code)
    3. Single click the check box that has the check mark, to uncheck and reset the box fill color to light blue.

    Note: I use multiple groups of check boxes to do different task. Each task has it's own group of check boxes,
    If I click a check box in Group 1, the check boxes in Group 2 and 3 has no effect. There are more than 3 groups.


    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Change check box fill color to unfill and clear check mark

    Before making checkboxes do what Option Buttons already do without code, can you explain why checkboxes and not Option Buttons?
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    Re: Change check box fill color to unfill and clear check mark

    Because the existing form using check boxes. I remark that form in Excel. The box fill color is just an visual
    effect. The minimum I can just use standard form control check boxes without any modifications. If I am
    concern someone may pick more than one box, I can add a note in the form "pick one box only" and or having
    visible warning if more than one box is checked.

    I like to make a proof spread sheet to avoid any accidentally someone may make two check boxes without notice.

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Change check box fill color to unfill and clear check mark

    I still don't understand why not option buttons.

    This will select one checkbox per group. I don't know about the shading.

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    Re: Change check box fill color to unfill and clear check mark

    Thanks. How about click the "Checked" check box to uncheck? The box is frozen. If I use the standard form control without VBA,
    I can toggle "Check" and "Uncheck".

+ 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. Click oval check buttons to fill and unfill color
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-19-2015, 09:00 PM
  2. [SOLVED] Click oval option button to fill/unfill color, also change border color to match fill
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-07-2015, 08:29 PM
  3. 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
  4. Replies: 2
    Last Post: 10-28-2013, 03:52 PM
  5. Check cell content has green color then mark as yes in another sheet.
    By dsk_qa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2012, 07:16 AM
  6. Macro for keeping track of certain data and returning a check mark or cell fill
    By skmcrodgers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-18-2012, 03:52 PM
  7. Replies: 3
    Last Post: 04-13-2005, 05:52 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