Hi,
Is there anyway to color each column in the listbox or any way to
change the font of individual listbox item.Since we can format the
items by currency or time format, i think that/s possible.
thanks for your help

Listboxes are text boxes with limited formating. You can change the color of
the text, but can't underline the text (I tried to underline last week and
was not sucessful).

You can use the excel format() statement to format the text prior to putting
the textt into the box. Reading the selected value to the text box again you
have tto convert the text back to numerical data. With dates you use
datevalue("Date string") and with currency you use val("$1.00"). If you want
the $ to appear in the worksheet, then you have to format the cells on the
worksheet to currentcy format.

" wrote:

Hi,
Is there anyway to color each column in the listbox or any way to
change the font of individual listbox item.Since we can format the
items by currency or time format, i think that/s possible.
thanks for your help