Conditional Formatting - Text Box

[belang46]

Hello all,

I am trying to conditionally format a text box (which is linked to a cell)...that if the value inside the text box doesn't equal a different cell's value, the background of the text box turns red.

I have no idea if the syntax is correct...I was looking at tutorials and just guessing (i don't name my text boxes, so i'm not even sure i'm calling it correctly...just going based on what i see in the cell reference box when i select the text box).

I'm a novice-my apologies if the answer is obvious.

Thanks for having a look and regards,
Marcus

Private Sub TextBox23_Change()
If TextBox("Text Box 23").Value = Range("L176").Value Then _
    TextBox("Text Box 23").BackColor = RGB(200, 160, 35)
End Sub

 

[Cease]

What kind of error is your code returning, or what's not working as you need it to?
I'm still a newbie with code, but at the least I feel you would need to end the if statement:

Private Sub TextBox23_Change()
If TextBox("Text Box 23").Value = Range("L176").Value Then _
    TextBox("Text Box 23").BackColor = RGB(200, 160, 35)
End If
End Sub

 

[belang46]

Thanks for the reply Cease...I tried that-still isn't working.

I'm not getting an error code actually-it's just not working at all. I am pretty sure my syntax is awfully far from the correct way.