Userform Listbox Row Source

[ldarley]

Hi all

I have a table displaying in my userform listbox I have set the rowsource to the table name (dossier) but it does not show the table headers, is there a way I can do this?

This is the line of code:

UserForm1.lstdisplay.RowSource = "Dossier"

Also if I get this to display will it remain fixed at the top of the listbox as the user scrolls down?

Many Thanks for any help

 

[RoryA]

Set the columnheads property to true, then the headers will appear (and will be real headers).

 

[Fluff]

Have you set the "ColumnHeads" property to true?

 

[ldarley]

Awesome, thanks so much that works great!

 

[Fluff]

Glad we could help & thanks for the feedback