View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
George George is offline
external usenet poster
 
Posts: 347
Default 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 ?