View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default Mouse click automatically enters character into cell.

Minor clarification: there is no Click or BeforeClick event for the
worksheet, so you would use the SelectionChange method which, as you point
out, has other triggers.

The BeforeRightClick method could be substituted for the BeforeDoubleClick
method if the OP doesn't want to click twice. <g
__________________________________________________ ______________________

"Gary''s Student" wrote in message
...
Hi Renee:

Your method would also work. I would still implement it with
double-click.
The problem with single-click is that the event triggers on ANY selection,
not just the mouse. So moving into the cell with the arrow keys would
also
trip the action.
--
Gary''s Student - gsnu200730


"Renee R." wrote:

Hi All,
Would it be possible to do this on one click by pre-populating the cells
with check marks in a white font and then having the color changed to
black
on the click event?

If so, how would one go about creating the code for that to happen
automatically?

"Jeffrey M. Coffin" wrote:

How can I set up a cell to respond to a mouse click by entering a check
mark?