I assume a "box" is actually a "cell"??I need to be able to click on a box and have it fil that box with a check, X, or other fill and have that fill go away if I click on that box again. Can I do that?
You haven't confirmed whether yout "box" is actually a "cell" or something else.When I double click on a box, it comes back with "Run-time error 13: Type mismatch." And when I click on debug, it highlights the second line, "If Target.Value = "" Then"
The best method may depend on the answers above. Which cells do you want it to work on?How do I assign which cells I want to use this formula on?
So you want to be able to click on some merged cells and have an "x" added or removed from the merged cells. Other merged cells you want to be able to click on and not add/remove "x" but be able to add data. Is that correct?I am sorry for the confusion. I have converted a form that we used to fill out and put it on an excell sheet. The boxes that I need to check and uncheck are actually a box that is formed from merged cells. there are other boxes that I have merged to put in information as well. So I need to be able to click once to check a box and click once to uncheck it if it was checked in error and be able to input data (words or numbers) in the other merged boxes. The whole sheet is protected except for the input boxes.
I hope this clarifies my issue. Thanks for your help.
Which cells do you want it to work on?