How to use ColumnHeads in a ListBox?

**aspicuelta** · 05-13-2010, 11:33 AM

Hi,
Can anyone post an example (or send a link for an already existing one) on how to program a ListBox so the first line is used as the column's header? According to VBA documentation, if the ListBox.ColumnHeads flag is set to TRUE, then the first line of the Column matrix is used as the column's headers, but there is no example on how the column's matrix should be build in these cases. If anyone has an example, I would like to have a copy of it. Many thanks.

**romperstomper** · 05-13-2010, 11:40 AM

It only works if you use the Rowsource property to bind the listbox to a range. Then the row above the Rowsource is used for the column headers.

**aspicuelta** · 05-13-2010, 12:36 PM

Originally Posted by romperstomper

It only works if you use the Rowsource property to bind the listbox to a range. Then the row above the Rowsource is used for the column headers.

It worked, perfectly.

Now just one more doubt (for anyone): Is there any way to make some of the columns at the left to be fixed? It means, without horizontal scrolling if the ListBox is wider than the displayed window.
Many thanks

**romperstomper** · 05-13-2010, 12:45 PM

No, unfortunately - if you have a scrollbar it scrolls everything.

**aspicuelta** · 05-13-2010, 12:50 PM

Originally Posted by romperstomper

No, unfortunately - if you have a scrollbar it scrolls everything.

OK, thanks

**royUK** · 05-13-2010, 01:53 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save