Working with MultiColumn ListBoxes

  • Thread starter Thread starter devlei
  • Start date Start date
D

devlei

I have a UserForm ListBox that has Mutlicolumns and ColumnHeads set to
"True". I have the following two questions:
1. How to set a value for each of the ColumnHeads?
2. How to right align a column of numbers?

With thanks
Dave
 
1) Outlook doesn't support ColumnHeads, even in VBA userforms, as I
discovered earlier this month.

2) Set the TextAlign property to 3? I think, though, that it's for the whole
control, not column by column, a limitation of the list box control. You
might have to left-pad the numbers with spaces.
 
Back
Top