Text Box Colour

[Flammabubble]

Hi all,

So I have the below code that I'm trying to use to get text box 6 to change colour whenever B10 changes colour. In this instance if B10 becomes green I want text box 6 to also go green, and if it goes white text box 6 also turns white. Unfortunately it doesn't seem to be working correctly - no errors, it just doesn't do anything. I have made sure I am changing it from the correct colour values so I am unsure what the problem is.

Please Login or Register  to view this content.

Does anyone have any suggestions?

[Norie]

Where is the code located?

[Flammabubble]

I tried putting it in the sheet as well as attached to a button. Ideally I would like it to happen automatically but I'm not sure if I can.

[Norie]

Did you try putting it in the Worksheet_Change event?

[Flammabubble]

No, but I am unsure how to use that function. The changing of the textbox colour what I am trying to do is probably best explained by the below
Button1:
IF B10=white, then B10 = GREEN
Then K10,N10,B16,E16,H16,K16,N16,Q16,T16 = WHITE
If B10 = White then textbox6=white. If B10 = Green then texbox6=green.

Button2:
IF K10=white then K10=Green
IF K10 = White then B10,N10,B16,E16,H16,K16,N16,Q16,T16=white
IF K10 = White then textbox7=white if K10 = Green then textbox7=green

The idea being that once a button is pressed, if the cell is white it becomes green and sets the other cells to white and subsequently the text box associated with it changes colour too. As I will need the text boxes to also update when other buttons are pressed (not just their own) I am trying to get it to automatically change