+ Reply to Thread
Results 1 to 4 of 4

Only one check mark allows in a group of form control check box

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

    Only one check mark allows in a group of form control check box

    Hello,
    I need help on form control check box.

    I want only one check mark allowed in a group of check boxes. When a check box is checked, then all other check boxes in that group will be unchecked.
    There are three groups, each group works independently.


    Thanks

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Only one check mark allows in a group of form control check box

    Use option button with Group box

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

    Re: Only one check mark allows in a group of form control check box

    Hello,
    I want to match the style of the square check boxes from an existing form but using Excel.
    I try to eliminate human error to check more than one check box.
    Last edited by Rocky2013; 03-01-2021 at 05:18 PM.

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,903

    Re: Only one check mark allows in a group of form control check box

    You're basically flying in the face of Windows design principles. Optionbutton = 1 of a group of choices; Checkbox = Select all that apply. FWIW.
    Rory

+ 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. Change check box fill color to unfill and clear check mark
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-16-2020, 03:20 PM
  2. Replies: 2
    Last Post: 10-28-2013, 03:52 PM
  3. [SOLVED] Need help with Form Control Check Boxes Please
    By colescharton in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-06-2012, 01:03 PM
  4. Can you use VBA to mark selected/deselect activeX control check box?
    By clemsoncooz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2012, 11:49 AM
  5. Check Box Form Control and no Font Tab
    By SueWithQuestion in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-05-2010, 12:46 PM
  6. [SOLVED] How do I put a check mark box in an excel document form?
    By Albert in forum Excel General
    Replies: 2
    Last Post: 07-07-2006, 12:20 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