Multi-columns in a ListBox
 

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.

Multi-columns in a ListBox
 

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.

--
Regards,
Tom Ogilvy

Tom Atkisson wrote in message
...
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.