Conditional Formatting a Text Box Excel 2010

[Judoman]

I have a text box in a spreadsheet. Want it to change to yellow whenever any text is typed into the text box.

 

[Eric W]

If it's an ActiveX control, select Design Mode from the Developer tab, then right click on the text box, choose View Code, then enter this line in the macro template:

    ActiveSheet.OLEObjects("TextBox1").Object.BackColor = RGB(250, 250, 0)

 

[Judoman]

I entered your string like this:
Sub TextBox1()
ActiveSheet.OLEObjects("TextBox1").Object.BackColor = RGB(250, 250, 0)
End Sub

Got a 'Reference is not valid' message

If it's an ActiveX control, select Design Mode from the Developer tab, then right click on the text box, choose View Code, then enter this line in the macro template:

    ActiveSheet.OLEObjects("TextBox1").Object.BackColor = RGB(250, 250, 0)

 

[Judoman]

Got Reference Not Valid I thing because I was still in Design mode. However, even out of design mode the box remains white when I type in it.

 

[RedBeard]

You didn't follow the instructions.
In Design Mode, Right click and choose View Code.

 

[Judoman]

I was in View Code.

 

[Eric W]

The whole macro is:

Private Sub TextBox1_Change()
    ActiveSheet.OLEObjects("TextBox1").Object.BackColor = RGB(250, 250, 0)
End Sub

Note that the subroutine name is "TextBox1_Change" not just "TextBox1". I assume that is the name of your text box, if not, substitute the actual name in both places.