Columnheads...

  • Thread starter Thread starter Jzz
  • Start date Start date
J

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
 
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.
 
Back
Top