Repost of Listbox Headers

[Mike Milligan]

For some reason I lost all newsgroup items posted from 10/7 thru 12:51pm
today. One of which was mine....I've tried downloading all and I don't get
anything....

Anyway, here's what I need.

I have a listbox that I populate view VBA. I do not have data in the
spreadsheet so I don't use RowSource. How can I programmatically name the
headers of my listbox?

Mike

 

[Dave Peterson]

I don't think you can.

Maybe you could put the data into a worksheet, add headers and use the
rowsource.

Or maybe you could get "creative" and add a label above the listbox that
describes the fields.