Multicolumn Listbox Widths

[M.Nolan]

I use a list of items from an excel sheet to fill a multi-column list box. I use:

Selection.ColumnWidth

to get the widths from the spread sheet... how can I convert this number from characters to points so that it can be used to set the column widths in the listbox.
I currently mulitply by 5 and it looks close but i'm looking for a more accurate conversion... I have looked around but cannot find much.
Thanks
Matt

[cssriraman]

Hi,

I think there is no straight way to find out the width of the characters group.

All the string characters will be having the same width in most cases. But symbols like (, ), ., #, $, %, etc. will have different widths. So, you should parse the string find out the length. then only you can find out the width of the text.