Screen coordinates transferred to image placement

[schmidt1962]

If anyone has ideas about this I would greatly appreciate it. I am looking for a macro or some vba language that I can modify. A user is presented with an image in excel of an aerial view. On top of that image, I want to enable whereever they decide to click, another image placed on top of it (the user selects the type of image prior to activating the mouse click.


When I have excel place the images, it does so whereever it decides. i want the user to decide where they are placed with the click of a mouse.

 

[patel45]

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
With ActiveSheet.Shapes.Range(Array("Picture 2")) ' change picture name
.Top = Target.Top
.Left = Target.Left
End With
End Sub

 

[schmidt1962]

This is sweet! Thank you! Just tried it out and think I can adapt to to what i need. Greatly appreciated.

 

[schmidt1962]

As a follow up, if I want to place images with labels 1, 2, 3,4,5 etc one at a time, how would I do that? Can you store pictures in an array, and call them out in a loop? Thanks for all your help

 

[patel45]

you can store pictures in an other sheet with names picture 1, 2 3 ... and call them out in a loop

 

[schmidt1962]

Patel - I have another question. I actually do store all my images in a worksheet called "Pictures". Can you help me out with a little more code? I thought that I had figured it out, but it isn't working. I am not quite sure how to do it. My goal is to copy the image from "Pictures" then place it on the aerial view on "Survey" worksheet.

Thank you!

 

[patel45]

paste here a link to a sample file with 3 images and your requests

 

[schmidt1962]

Patel,

I have posted of file here:
http://www.sendspace.com/file/kmwld6

The goal is, to have the user be able to select which images (numbers) they want, then go to the map and fire them with the mouse in the location desired (as opposed to having them placed there by the loop).

Thank you for your help. Much appreciated.

Eric

 

[schmidt1962]

Patel, thought I would follow up. Did you get a chance to check out the file? Thanks

 

[patel45]

I'm sorry, I misread your first post, I'm not able to