View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
ties ties is offline
external usenet poster
 
Posts: 3
Default onclick event for cell

bedankt!

I'm sure this must work great!

Regards,
Thijs van Bon

"Jan Karel Pieterse" schreef in bericht
...
Hi Ties,

So far I have used Workbook_SheetSelectionChange, with which I can

monitor
whether a cell is selected... This works pretty well, but it also reacts
when a user is scrolling the cursor with the arrow-keys over the cell

and
offcourse doesn't react when the cell is already selected and the user
clicks the cell.


You could place a label control from the control toolbox on top of the

cell
you wish the click event for and use the click event of the label. Make

sure
the label has no caption and has the background and border set to none.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com