View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default VBA ComboBox Text Color

Assuming you are using a combo box from the control toolbox there is a
ForeColor property which refers to the font color. That bing said it applies
to the combo box and not the individual items in the combo box. That being
the case you only get one font colour for all entries. No rainbows allowed.
--
HTH...

Jim Thomlinson


"jlclyde" wrote:

Is there a way to change the font color as it is loaded into a form on
a combobox? I have items that I am adding to a form and I want to
keep the font color that is on the worksheet.

Thanks for looking,
Jay