format listbox columns

  • Thread starter Thread starter ranswrt
  • Start date Start date
R

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
 
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
 
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
 
Back
Top