Set the text align property of each individual column on UserForm1.ListBox1.ColumnCount = 5

[Drom]

Hi!

I have a UserForm "UserForm1"
This Userform has a ListBox "UserForm1.ListBox1"
This ListBox's, ClumnCount = 5, "UserForm1.ListBox1.ColumnCount = 5"

Now is it possible:
To set the text align property of each individual column ??

Kind of:
UserForm1.ListBox1.TextAlign = fmTextAlignRight
UserForm1.ListBox1.Column(3).TextAlign = fmTextAlignLeft
UserForm1.ListBox1.Column(5).TextAlign = fmTextAlignCenter

THANKS!!

[Norman Jones]

Hi Drom,

> Now is it possible:
> To set the text align property of each individual column ??

The individual columns do not have an alignment property. The ListBox's
AlignText property sets the alignment for all columns.


---
Regards,
Norman

"Drom" <NoSpam@hotmail.com> wrote in message
news:ek43Wce1FHA.2964@TK2MSFTNGP09.phx.gbl...
>
>
>
> Hi!
>
> I have a UserForm "UserForm1"
> This Userform has a ListBox "UserForm1.ListBox1"
> This ListBox's, ClumnCount = 5, "UserForm1.ListBox1.ColumnCount = 5"
>
> Now is it possible:
> To set the text align property of each individual column ??
>
> Kind of:
> UserForm1.ListBox1.TextAlign = fmTextAlignRight
> UserForm1.ListBox1.Column(3).TextAlign = fmTextAlignLeft
> UserForm1.ListBox1.Column(5).TextAlign = fmTextAlignCenter
>
> THANKS!!
>
>

[Leith Ross]

Hello Drom & Norman,

Just a side note. In Visual Basic 6.0 it would be possible because the control has a window handle property (hWnd). Using the Applications Programming Interface (API) you can control the individual alignments. Unfortunately, this isn't the case in VBA.

Sincerely,
Leith Ross