Hi Jim

You would really help me with a simple example.

I've loaded the ListView into the toolbox and inserted it, but i don't see
how to control alignment for multiple columns.

Regards,

Claus



"Jim Rech" skrev i en meddelelse
...
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
|
|
|