Unable to create VBA coding for Text Box Click event

Hi All,

I'm hoping someone will be able to assist me; I am having difficulty creating a MS Excel 2003 VBA Click Event for a text box to change the fill colour. There are twelve Text Box's grouped together pertaining to each month of the year and the idea is to alter the colour depending on a Red, Amber, Green Performance. The coding below works as a freeform click event however for a Text Box it returns a runtime error 70.

Please Login or Register  to view this content.

I have tried using Macro Recorder to find another method to no avail. However, below are the parameters for colour coding I wish to achieve.

Please Login or Register  to view this content.

Can anyone please help, I have tried different connotations and still struggling.

your first code snippet works for me in 2003. I reckon your issue may be related to the fact you have grouped the textboxes-does it work if you ungroup them?