Hello NG,

on a UserForm, I have got a multicolumn ListBox. 2 questions:

(1) Is it possible to fill a multicolumn listbox out of an array
variable, without the need to specify a RowSource from a worksheet, but
including column heads?

(2) Is there a possibility to let Excel sort the listbox items after a
click on the column headers, taking that column as the search criteria?

Thank you in advance,
Jens

- peterDavey: I got no reply to my posting, that's why I am asking again.