VBA Get Name of Picture

[JimmyA]

Hello All

I hope this is easy to explain....

If I had say three pictures on a sheet all with the same macro assigned to them (the reason being that the name of the picture would dictate what happend in the macro) is it possible to get the name of picture that was clicked on to run the macro?

So for example if the pictures were named Department 1, Department 2 and Department 3. Clicking on each of them would run the same macro but the picture name could then be used further in the macro

I know this wont be it but I was hoping I would be able to do something like......

Please Login or Register  to view this content.

Any hints would be great.

If you need me to explain further, please let me know.

Thanks in advance.

Jim

[romperstomper]

Application.Caller will return the name of the object in your macro.

[JimmyA]

Great Stuff

Thanks very much romperstomper, I hoped there would be something like that.

Thanks again

Jim