Shape macro

[lukemason12]

Hi all,

I am after a macro that when a button is clicked it changes the colour of a shape to say if the statement is complete, working towards or incomplete. I then need a cell to be linked to the cell so that if it is complete the cell shows 3, working towards 2, incomplete 1.

I have a macro that fills the shapes fine but I cannot work out how to make a cell change value depending on the shape colour. There are roughly 36 shapes per worksheet.

Any help would be great.

Thanks,
Luke

 

[lukemason12]

Yondle this works a treat. Thankyou very much.

 

[Yongle]

Glad you made it work for you