Multi-columns in a ListBox

  • Thread starter Thread starter Tom Atkisson
  • Start date Start date
T

Tom Atkisson

I recently found out about Multi columns in a list box and was wondering
about a few things.

1. Can you have different widths of each column ?

2. How do you Assign a Header to each column, if you can ?

Thanks in advance.
 
Yes, look in Excel VBA help at the columnwidths property of the listbox.

You can only have a header if you populate the listbox with the Rowsource
(userform) property or the ListfillRange (worksheet) property. Then the
columnheader is obtained in the row above the rowsource or listfill range.
 
Back
Top