Setting headers in a listbox programmatically

[conorohio]

Hi,
I am programming a user interface in excel 2003, windows XP.

My code uses buttons to switch between two sets of information displayed in a listbox. However, since the the two sets of information do not have the same column headers, I need to redefine column widths and header names everytime I switch between them.

I can redefine column widths (historyBox1.ColumnWidths = "53 pt;110 pt;47.95 pt etc...) however I can't figure out a way to set the column headers. I would have guessed it would look something like-

historyBox1.Column(0).header = "Date"
historyBox1.Column(1).header = "City"

but I can't find anything that works like this. Does anyone know how to do it?

Thanks

 

[jindon]

How are you populating the list?