(Solved) – Is there a way for excel to recognize which shape having macro assigned was clicked?

(solved)-–-is-there-a-way-for-excel-to-recognize-which-shape-having-macro-assigned-was-clicked?

I have added a few shapes to my worksheet. I have assigned macros to them. But I had to create separate macros for all.

Is there a way for excel to recognize which shape was clicked and based on its text value find the cell to copy. That way I need not have to create separate macros for each shape.

I have tried searching for it online, found a few things which I tried but did not work.

Any help would be greatly appreciated.

Leave a Reply

Your email address will not be published. Required fields are marked *