Column Heads in Forms 2.0 ListBox control
Posted on 1998-02-18
I'm doing some programming for Outlook using VBScript, and I need to use a control that can display data in a list with multiple columns. I have been using the ListBox control (MS Forms 2.0).
To display column heads, I set the ColumnHeads property to true:
ListBox.ColumnHeads = True
This creates space for the column heads at the top of the list box. However, I have been unable to figure out how to actually put a heading in the ColumnHead area. Anyone have any suggestions?
I did look in Excel's Object Browser, and the Help file for ColumnHeads just says the following:
"When the system uses the first row of data items as column headings, they can't be selected." (Copyright(c) 1996 Microsoft Corporation.)
I'm not even sure what this means. How can I "get" the system to use the first row of data items as column heads? Everything I've tried has failed.
If you can't answer this question, I'd appreciate some comments with suggestions of good alternatives. My requirement is 12 columns, and the ability to put headings on the columns.