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.
' ShBox is the name of sheet where user clicked on an object to run a macro
PicNam = ShBox.Shapes(Application.Caller).Name
Views 87
Downloads 40
CodeID
DB ID