ShapeName clicked

Simple command to know which object (shape) the user clicked
When you assign a macro to be executed when a shape is clicked, you can tell which shape the user clicked using command below.

CodeFunctionName
What is this?

Public

Tested

Original Work

' ShBox is the name of sheet where user clicked on an object to run a macro
PicNam = ShBox.Shapes(Application.Caller).Name

Views 89

Downloads 41

CodeID
DB ID