Colour items in Userform Listbox

Hi,

I have a userform which displays negative values from cells. I want each value (Listbox item) to be coloured with red, If value of cell is lower than "-200:00".

I searched a lot and found that It probaly can't be done in Listbox control, but found that maybe It can work with Listview control (according to Charlize's code from forums).

I tried that too, but just can't figure out how to fix a code that would work for me

This is a code for listbox :

Please Login or Register  to view this content.

...And I've attached a listview control and copied Charlize's code into Userform (and commented It), but cannot fix It.


Could someone please let me know If It's possible to solve this problem with any of these ways, or other

See attached sample !!

Perfect, It works

Can I have only two ColumnHeaders to display or must I change width of control, now I see third ColumnHeader too !

Tried wiith ColumnHeaders.Count=2, but not working !

Perfect, It works

Can I have only two ColumnHeaders to display or must I change width of control, now I see third ColumnHeader too !

Tried wiith ColumnHeaders.Count=2, but not working !

I just resized Listview, It doesn't matter, thanks for your code !!!