I have a multicolumn listbox that I've been using for sometime. I've
recently decided I want to add column headers to the listbox. I set
columnheads to true, but have not found a way to programmatically add the
header names. How do I do this?

Thanks in advance for reply,
Mike

I believe you just set the header cell values to what you want them to
be. No special property assignments are necessary for the cell.

So if your headers are in A1, B1, C1

Range("A1") = "myheader1"
Range("B1") = "myheader2"
Range("C1") = "myheader3'

You have to set RowSource to a spreadsheet range that is just below the
column headers you want, but does not include them.

For example, if your headers are in A1:C1 and the data is in A2:C10, you set
RowSource to A2:C10.

http://support.microsoft.com/kb/211899

--
Jim
"Mike Milligan" wrote in message
...
|I have a multicolumn listbox that I've been using for sometime. I've
| recently decided I want to add column headers to the listbox. I set
| columnheads to true, but have not found a way to programmatically add the
| header names. How do I do this?
|
| Thanks in advance for reply,
| Mike
|
|

That works great if I'm using Rowsource. How do I get headers when I am
populating the listbox via VBA (ie. the data isn't in a spreadsheet)?

"Jim Rech" wrote in message
...
You have to set RowSource to a spreadsheet range that is just below the
column headers you want, but does not include them.

For example, if your headers are in A1:C1 and the data is in A2:C10, you
set
RowSource to A2:C10.

http://support.microsoft.com/kb/211899

--
Jim
"Mike Milligan" wrote in message
...
|I have a multicolumn listbox that I've been using for sometime. I've
| recently decided I want to add column headers to the listbox. I set
| columnheads to true, but have not found a way to programmatically add
the
| header names. How do I do this?
|
| Thanks in advance for reply,
| Mike
|
|