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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform Listbox column heads??? 1
Listbox headers 3
Adding Headers to a listbox 3
Sorting multicolumn listbox 1
multicolumn listbox 9
Listbox Column help 2
Multicolumn Listbox 5
Listbox with Multiple Columns 4

Back
Top