Vba in shapes

[ahmadan63]

Dears,
I have a rectangular shape as a source and I assigned a macro to it to save some data in it
now i want to copy this shape in different places in a sheet and when i click on each of them i would like to put different values, but when i copy it the same macro (source one) with the same values exist,
how can I have an exclusive shape when i copy source shape?

thanks for your help in advance
H.Ahmadian

 

[RickXL]

Hi and welcome to the MrExcel Message board.

After you have copied your shapes you will need to right-click each one in turn and change the macro name to the one you want.

 

[ahmadan63]

Hi and welcome to the MrExcel Message board.

After you have copied your shapes you will need to right-click each one in turn and change the macro name to the one you want.

Hi
thanks for your reply
i know i can copy it but as i said when i even copy the source shape i can also put the different values for each shape in different rows and culomns in a sheet but my question is suppose i copy 10 shape in a sheet and through them i put different values in a different sheet but i want when i click on a for example 3rd shape it shows me the data that i entered for this shape not the last one. You re right i can right click and rename it but suppose a biggener wants to hse this spreadsheet
thanks