format listbox columns

[ranswrt]

I have a listbox with 7 columns. How do i format the last 5 columns as
currency with the negative amounts in parenthesis and red?
Thanks

 

[paul.robinson]

Hi
Do it on the worksheet before you pull it into the listbox. If not on
the worksheet, do it in a hidden worksheet then lift to listbox
regards
Paul

 

[ranswrt]

It is already formated that way on the worksheet. I would like to be able to
format it on the listbox because if I do it using rowsource it clear all the
items that have been selected. What is the best way to do that and not loose
the items that have been selected?
Thanks