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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formating listbox columns 8
Populating a listbox from an excel column 2
Listbox Column help 2
Listbox Formating 1
Formatting 8
ListBox Remove Certain Text 6
color font for listbox column 1
Listbox Problem 1

Back
Top