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
|