Listbox - 1 item have a color background

[Josh_123456]

I have a listbox on a userform that's rowsource is a1:a200


On sheet1 a35, the background color is green, however this doesn't show up in the list box.


Is there anyway for the listbox to show background color's relating to cells, or possibly different colored fonts?


thank you for any help

Josh

[Leith Ross]

Hello Josh,

You can make the colors match. The catch is you must use a Control Toolbox ListBox not a Forms ListBox. You can still link the Control Toolbox to your range by setting the ListFillRange either manually using the Properties window or by code.

Please Login or Register  to view this content.

Sincerely,
Leith Ross