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

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
>
>

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
>
>