How to Re - run a code (Refresh?)

[gift]

Hi all,

I have an excel sheet with vba codes that run based on selection of a drop down list. The issue comes when I copy one of the options and paste them on another cell. the macro wont run. it needs me to reselect the option in that cell again. All I want is some refresh button to enable the macro to run and apply to those cells. Please see attached.

Thanks in advance.

Gift

 

[chirayu]

I have modified the code & deleted out all the unnecessary bits.

 

[gift]

I have modified the code & deleted out all the unnecessary bits.

Hey Chirayu,

Thanks so much for your help. Can I ask one more thing. You would have noticed that in the code I try to centre the shape by moving it 36/37 points to the right. is there any way that I can make the shape centred and in the middle of each cell. Please see attached.

Thank you

 

[chirayu]

I modified the 'move shape' section of the macro based on below link

http://www.excelforum.com/excel-pro...cro-to-center-a-shape-in-a-cell-in-excel.html

 

[gift]

I don't know how to thank you. Thanks so much. You just made me look like a genius.