I tried to email you my simple example file but Hotmail said your address
wasn't valid :(


--
Jim
"Claus" wrote in message
...
| Hi Jim
|
| When using:
| UserForm1.ListViewCtl1.ColumnHeaders.Add 2, , "Col2", 70, 2
|
| It get the Run-time error 438:
| Object doesn't support this property or method.
|
| I use Excel 2002 SP3, with VBA 6.3.
|
| Regards,
| Claus
|
| "Jim Rech" skrev i en meddelelse
| ...
| Alignment is set when you create the column header.
|
| LV.ColumnHeaders.Add 2, , "Col2", 70, 2
|
| The last "2" makes this column center aligned. The only documentation I
| know of is on MSDN:
|
|
http://msdn.microsoft.com/library/de...umnheaders.asp
|
|
| --
| Jim
| "Claus" wrote in message
| ...
| | 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
| | |
| | |
| | |
| |
| |
| |
| |
|
|
|
|