Further to Tom I would add that the ListView control does add alignment
functionality along with a bunch of other things the listbox control lacks.
I recently 'discovered' it reading 'Professional Excel Development' by
Stephen Bullen et al. It seems that all machines with recent Office
versions installed will have this control available. It has to be added to
VB Toolbox palette since it's not part of VBA proper.

If you'd like a truly simple example workbook let me know.


--
Jim
"Claus" wrote in message
...
| Hi
|
| I need to control the alignment and format of colums in a listbox that i
| fill using array.
|
| I need columns 1, 4,5,6 and 7 to be right aligned
| I need columns 1, 4, 5 and 6 to be formatted like this #.###,##
| i've done like this with column 1 in the code: MyArray(Rk, 0) =
| Format(Selection.Value, "##,#0.00")
|
| I need column 7 formatted as percentage.
|
| See the attached picture.
|
| Hoping for help.
|
| Claus Persson
|
|
|