Display selected picture value in a cell

[pajc72]

Good afternoon,

I have a number of pictures on sheet 1 that display names from cells in sheet 2
e.g.
Cell B1 in Sheet 2 has the value "Bob Jones"
Cell B2 in Sheet 2 has the value "Ian Jones"

In sheet 1 Picture1 has the formula =Sheet2!$B$1 so that the picture displays "Bob Jones"
Picture2 has the formula =Sheet2!$B$2 so that the picture displays "Ian Jones"

I have about 30 pictures displaying names in this way, but I want the name of the chosen picture to also appear in cell A1
e.g,
On sheet 1 user clicks on Picture 1 (Bob Jones), the name "Bob Jones" appeas in Cell A1
user clicks on Picture 2 (Ian Jones), the name "Ian Jones" appeas in Cell A1

Any help will be appreciated

Thanks
Pete

[pajc72]

I have been looking around some forums and it seems the solution may be around the Application.Caller function. I tried it with

Please Login or Register  to view this content.

to try to get the selected picture name to appear in cell A1 but still not working