Novice method? Not that I know of. Give this a try... right click the tab at
the bottom of the worksheet that you want this functionality on, select
"View Code" from the popup menu that appears and copy/paste the following
code into the code window that appears...

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _
Cancel As Boolean)
Cancel = True
Target.Value = IIf(Target.Value < "", "", "X")
End Sub

Now, go back to your worksheet and double-click an empty cell to put an "X"
in it, double click any cell with text in it (an "X" or anything else) and
the text will be cleared. Is that what you were looking for?

--
Rick (MVP - Excel)


"George" wrote in message
...
Any Cell - A double click would be OK,
is there a novice method ?

Thanks



"Rick Rothstein" wrote:

Any cell? A particular cell? Cells within a particular range?

Also, would a double-click be alright? Event code for a double-click can
be
written quite easily to do what you ask, but a single click is not as
"smooth" acting. To do a single click would require using a
SelectionChange
event, but doing so would mean that if you clicked a cell by mistake, you
would have to click into any other cell before clicking back into the
cell
where you made the mistake in order to clear it.

--
Rick (MVP - Excel)


"George" wrote in message
...
Can I create a method that when you click on a cell it will
enter a Check Mark or an X ?