How to add data to "ColumnHeads" in Excel VB ListBox ?

[sam_d1]

Hi all,

I have a ListBox on a UserForm in an Excel VB Project.
One of the properties of ListBox is "ColumnHeads". When I make this 'True', add data to the list and run, I get a box in the first row of the list.

As expected this box remains even when I scroll down the list.

But I am not able add any data to this first row. Even the first data I add (to the list) is displayed from the second row.

Can someone help me to add data to the "ColumnHead" ?

Note : I am using
"MicroSoft Forms 2.0 ListBox", (MF20.DLL)
not the "ListView"

Thanks in Advance
- sam

[Juan Pablo González]

I've only used this option using "real" ranges from Excel, not adding the items on the fly... I don't know if you could add titles on the fly....

[Dave Hawley]

Hi sam

To have ColumnHeads included you must exclude your firt row in the RowSource Property. For example if your data table is "A1:K1000" you MUST use: "A2:K1000" to have row 1 as your ColumnHeads.

[sam_d1]

Hi Juan Pablo & Dave Hawley,

This is GREAT....

I am amazed by the speed...

Thank you very much
- sam

[GnarlyVBA]

Thanks, I learned a simple solution after an intense search on the www. Thank You!