Codepended Check Boxes

**igormigor** · 01-28-2016, 08:59 AM

Hi all,

I have 2 check boxes in sheet. Each of them controls separate cell. If I check Box1, cell B12 will show "True". If I check Box2, cell B14 will show "True".
I need when I check one of the boxes, the other one automatically to be unchecked. In same time only one box can be checked.

Below is my code. There is conflict in it and does not work properly.

Please Login or Register  to view this content.

Any ideas how to fix this?

Thank you

Igor

**Kaper** · 01-28-2016, 09:09 AM

Hi Igor,

If I understood you well, you are using ActiveX Cheeckboxes, and want to have always one checked and the other not (may be not in initial state, but once one is checked first time).
In this case you probably do not really need two checkboxes, one would be enough. but:

Please Login or Register  to view this content.

and similar code, but with opposite references for the second one

**Kaper** · 01-28-2016, 09:12 AM

But if you allow 3 options any time:
- both false
- 1st true 2nd false
- 1st false 2nd true
try:

Please Login or Register  to view this content.

or shorter:

Please Login or Register  to view this content.

(and similar but opposite for second one)

**igormigor** · 01-28-2016, 09:37 AM

Hi Kaper,

THATS PERFECT!!!!!
for me works the second option.

Thank you a lot!!!.
Igor

Codepended Check Boxes

LinkBack

Thread Tools

Rate This Thread

Display

Codepended Check Boxes

Re: Codepended Check Boxes

Re: Codepended Check Boxes

Re: Codepended Check Boxes

Thread Information

Users Browsing this Thread

Similar Threads

Check boxes that delete other check boxes and change the color of another cell.

[SOLVED] Coding Yes/No option buttons to not allow check boxes or require check boxes

[SOLVED] How to Count Check Boxes and count the total number of boxes checked

Copy row that contains check boxes without the check boxes being linked

Automatically check one or more check boxes when a parent check box is manually checked

I need a code for presence check to check multiple text boxes and combo boxes

Automatic setting of check boxes based on other check boxes?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions