Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional prevention of check mark in a cell
Hello,
I have a worksheet that has two cells in which I can double click to either add or remove a check mark. This code is working. I now want to add code in which if one box is checked, then it doesn't let you put a check mark in the other cell. I am new to VBA and macros. I have learned quite a bit just playing around with it and searching solutions online. But, this one seems to be avoiding me. Thanks for any help you can give. Will |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional prevention of check mark in a cell
Posting your original code will make it easier for someone to offer a
solution, but the suggestion below might help. Assuming one of your cells is A1 and you're using something like Wingdings character 252 for the tick: If Range("A1").Value < Chr(252) Then ' your existing code here End if -- Ian -- "mrwill" wrote in message ... Hello, I have a worksheet that has two cells in which I can double click to either add or remove a check mark. This code is working. I now want to add code in which if one box is checked, then it doesn't let you put a check mark in the other cell. I am new to VBA and macros. I have learned quite a bit just playing around with it and searching solutions online. But, this one seems to be avoiding me. Thanks for any help you can give. Will |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check Mark in a cell | Excel Worksheet Functions | |||
How can I add active tick mark/check mark boxes in excel? | Excel Discussion (Misc queries) | |||
Cannot check the check mark box in cell | Excel Worksheet Functions | |||
Click on a cell to get a check mark then... | Excel Programming | |||
How do you replace a yes value in a cell with a check mark? | Excel Discussion (Misc queries) |