get cursor position when clicking on an image

[timspier]

I want to be able to insert an image, say a jpeg or bmp, into a
worksheet. Then, I want to be able to click on a spot on that image and
have Excel record the X,Y coordinates where I clicked. I need to click
on several spots on an image and record the X,Y coordinates of each
spot, then determine the distance between spots. Any ideas?

 

[NickHK]

timspier,
Whilst you could assign a macro to the picture, you would somehow have to
translate the current mouse coordinates into those relative to picture.

Images on worksheets don't have events, but the image control does. You get
the coordinates in the Image1_MouseDown event.
Set it to .Autosize=true, so no blank space.

NickHK

 

[timspier]

Hey, great idea! I looked into this, looks like it might work. Thanks!