EXCEL Populate multi column listbox from variable worksheet rows

[badscottish]

Hello all,

I have an excel form with a listbox containing 5 columns. My aim is to populate the listbox with data from the spreadsheet, always 5 columns but the rows may be variable. How do I code this??? Also, How do I populate the column headers???

Thanks in advance...

 

[PHV]

Have a look at the RowSource and ColumnHeadings properties of the UserForm.ListBox object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886