getting image cell location

[reyes]

Hello y'all!

i need some minor help with Excel 03, i have a image in
cell G12, i want to assign a macro to it that would give me the
location of that image within the spreadsheet, so in this case, it
should pop up with "G12" when i click on the image.

I know how to assign a macro to a picture, but having trouble with the code.

The code should be able to look at the location of the image, and
determine the cell that the image is in.

Please Login or Register  to view this content.

[jasoncw]

Something like this will work:

Please Login or Register  to view this content.

BTW, please wrap your code above in CODE tags as per the forum rules. Thanks.

Jason

[Leith Ross]

Hello reyes,

If you are looking for a picture, it is better to look for the picture than a generic Shape on the sheet.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[reyes]

Thanks Jason & Leith,

Leith your code is more dynamic that can be included in multiple images and still functions when images are moved around in the sheet, so it works best.

One last request i have is how to i add cells (rows or columns) in excel?

example

Please Login or Register  to view this content.

In the code above how do i add 3 columns to whats in "Pic.TopLeftCell.Address" ?

Please Login or Register  to view this content.

Thanks again for your valuable input.

[Leith Ross]

Hello reyes,

Here is how to place the date and time in the cell 3 columns to the right of the pictures upper left corner. Depending on the width of the picture, this cell could be covered.

Please Login or Register  to view this content.

Sincerely,
Leith Ross