View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default get reference to cell from mousedown event

An Image control will have a click event. Obviously, since you write the
code for the click event, you already know which control it belongs to. You
can then use that information to get the topleftcell.

Private Sub Image1_Click()
MsgBox Image1.TopLeftCell.Address
End Sub


--
Regards,
Tom Ogilvy


"David" wrote in message
...
I have several activeX image controls on a worksheet. When the user clicks

on
an image I would like to return a reference to the worksheet cell

underneath.
Unfortunately the "me" keyword does not return the name of the control,
otherwise I could use "me" and TopLeftCell. Maybe I could work with the x

& y
co-ords returned by the MouesDown event?
Any Ideas?
--
David