ExcelBanter - Alignment and format in listbox columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Alignment and format in listbox columns (https://www.excelbanter.com/excel-programming/338168-re-alignment-format-listbox-columns.html)

Alignment and format in listbox columns

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
|
|
|

Alignment and format in listbox columns

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
|
|
|

Alignment and format in listbox columns

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
| |
| |
| |
|
|
|
|

Alignment and format in listbox columns

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
| |
| |
| |
|
|
|
|

Alignment and format in listbox columns