you can't single click - this would be the same as selecting the cell, so
you can use the SelectionChange method

"sunilpatel" wrote in message
...
Is there a way to activate code on a "Single" click in the activecell /
selected cell on sheet.

i have "no" in cell "a1" and it is selected. i want it to change to "yes"
if i single clik on "a1"

Probably not possible hey?

Sunil