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.

If Sheets("Tally").Range("B10") = RGB(255, 255, 255) Then
TextBox6.BackColor = RGB(255, 255, 255)
ElseIf Sheets("Tally").Range("B10") = RGB(0, 255, 0) Then
TextBox6.BackColor = RGB(0, 255, 0)
End If
Does anyone have any suggestions?