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

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