Columnheads...

[Jzz]

I know this has been posted many times before, but I give it a try
anyway.

I know it is not possible to fill the columnheads of a listbox on a
userform without using Rowsource. As I need to fill the listbox using
'List', is it not possible to make a fake rowsource in a sheet to fill
the heads, then fill the rest of the box using 'List'?

Hope so..

Jzz

 

[Tom Ogilvy]

no.

 

[Tom Ogilvy]

Here is another way to put it

Rule 1: "it is not possible to fill the columnheads of a listbox on a
userform without using Rowsource"
Rule 2: If you need to fill the listbox using List and want to have
columnheads, see rule 1.


the workaround is to populate list and then transfer/write the data from
list on the sheet, add headers in the first position and apply Rule 1.