ComboBox ForeColor propery

  • Thread starter Thread starter Wayman Bell
  • Start date Start date
W

Wayman Bell

I have a form with several cells with conditional formatting set so that
when the form is cleared this range("cells").Value = "need info". When the
cell value = "need info" then the text color changes to red.

The form also contains several combo boxes, some are 2 column with linked
cell, that are also reset to .value "need info".

Problem; I have not been able to change the color of the text in the combo
boxes to red only when the value is "need info". I can do this all day long
for combo boxes in Access VBA but have not been able to get the desired
results in Excel.

Thanks for any ideas,

Wayman
 
Wayman,

ActiveSheet.ComboBox1.BackColor = RGB(255, 255, 180)

The combo box must be an ActiveX one, from the Controls Toolbox.
 
Thanks Earl, works like a charm.

Wayman

Earl Kiosterud said:
Wayman,

ActiveSheet.ComboBox1.BackColor = RGB(255, 255, 180)

The combo box must be an ActiveX one, from the Controls Toolbox.
Click to expand...
 
Back
Top