column heads in excel vba

[bunny1]

Im trying to add coloumn heads to my listbox but its just not working
i was using rowsource to use the first row of the sheet as the headings however this just set the values in the listbox to the rowsource

Here is my code

Please Login or Register  to view this content.

Any help would be much appreciated

[royUK]

Not sure what your code is doing, but have you set the ListBox's ColumnHead Property to True?

Please Login or Register  to view this content.

[bunny1]

I use the following code

Please Login or Register  to view this content.

But this just puts row 1 in the listbox and not the values i want to display under the headings

How can i use the headings from row A1 to H2 without wiping out the values i display in the listbox?

[royUK]

Try

Please Login or Register  to view this content.

[Andy Pope]

Cross post
http://www.ozgrid.com/forum/showthread.php?t=93725

[bunny1]

it's throwing an error

"wrong number of arguments or invalid assignment"

i dont really understand the rowsource line of code so i cant see where it's going wrong

thanks so much for the help

[royUK]

Sorry there was a typo, corrected now.

Please make sure to read the rules about cross posing.

Please Login or Register  to view this content.