ComboBox ForeColor propery

[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

 

[Earl Kiosterud]

Wayman,

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

The combo box must be an ActiveX one, from the Controls Toolbox.

 

[Wayman Bell]

Thanks Earl, works like a charm.

Wayman

Wayman,

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

The combo box must be an ActiveX one, from the Controls Toolbox.