Is it possible to use Listbox Headings with AddItem?

GeorgeAdamson · Feb 25th, 2002, 05:24 AM

Hi everyone,

I'd like to use the ColumnHeads feature of a listbox control but according to the vba help you can only show headings if the data is linked to cells on the spreadsheet. I need to populate the list using AddItem or the List property, so is there really no way to show column headings without linking?

Many thanks

PS: And no, I don't want to do solve this by copying the data into cells and then linking to them, because the process must be very fast.

Robb · May 14th, 2002, 10:46 AM

Thought I would bring this to the front again, since I am in a similiar situation. Does anyone out there know the solution?

Add custom ColumnHeads?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 25th, 2002, 05:24 AM	#1
GeorgeAdamson New Member Join Date: Feb 2002 Posts: 14	Hi everyone, I'd like to use the ColumnHeads feature of a listbox control but according to the vba help you can only show headings if the data is linked to cells on the spreadsheet. I need to populate the list using AddItem or the List property, so is there really no way to show column headings without linking? Many thanks PS: And no, I don't want to do solve this by copying the data into cells and then linking to them, because the process must be very fast.

May 14th, 2002, 10:46 AM	#2
Robb Board Regular Join Date: Feb 2002 Location: Winnipeg, Manitoba, CANADA Posts: 130	Thought I would bring this to the front again, since I am in a similiar situation. Does anyone out there know the solution? Add custom ColumnHeads?