| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
TextBox Color Red if Less than 50
Sorry, I couldn't tell if you were trying to change the font color or
the text box color. my previous post will change the text box color, the code below will change the font color. Private Sub TextBox1_Change() If TextBox1.Value < 50 Then TextBox1.ForeColor = &HFF0000 Else TextBox1.ForeColor = &HFFFFFF End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| set color of textbox (shape) bullets | Excel Programming | |||
| How to have textbox font color change? | Excel Programming | |||
| Match TextBox Back Color to Cell Fill Color | Excel Programming | |||
| TextBox Color Change | Excel Programming | |||
| Browse Forms Controls and change TextBox color based on cell color | Excel Programming | |||
Threaded Mode
