+ Reply to Thread
Results 1 to 2 of 2

Allow only one CheckBox per line to be checked.

  1. #1
    Registered User
    Join Date
    10-12-2012
    Location
    Everett, Washington, U.S.A.
    MS-Off Ver
    Excel 2007
    Posts
    1

    Allow only one CheckBox per line to be checked.

    I am new to all of this and don't know how to fix it so that only one on the boxes of the same line can be checked. If there is a check in column C I don't want a check to be allowed in column F and vis versa.
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: Allow only one CheckBox per line to be checked.

    Hi kdstokes208 and welcome to the forum.

    When you add check boxes it makes the whole problem harder. How about using a simple "x" in a cell to show it selected or not. See the attached workbooks that use code that double clicks on cells and adds or removes an x from the cell. Then you might do a little more VBA to insure both aren't checkde per row.

    Find some old examples I have saved in the past to show double click to x.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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