Auto Check Mark
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 ?
|