How to click on a shape and make its duplicate

[sbatabyal]

Hi guys,

I am currently trying to figure out a way so that while clicking on a certain shape creates a duplicate of that shape. What I currently have is a Clone Me button which while clicking on it creates a duplicate of any selected cell, for that you have to select a shape first then click on clone me button to create a duplicate which could be achieved by ctrl+c and ctrl+v as well. I am looking for an easy way for this such that while clicking on a shape will create the duplicate of the shape. Attached is the code which I have:

Please Login or Register  to view this content.

[AlphaFrog]

Right-click on the shape and assign the macro below.

Please Login or Register  to view this content.

[sbatabyal]

@AlphaFrog
Worked like a charm, Thanks.