View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.