Columnheads...

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
 
T

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top