Columnheads...
 

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

Columnheads...
 

no.

--
Regards,
Tom Ogilvy


"Jzz" wrote:

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

Columnheads...
 

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.
--
Regards,
Tom Ogilvy

"Jzz" wrote:

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