dmacioce
asked on
Column Heads in Forms 2.0 ListBox control
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
MS Flexgrid is probably better actually! thanks for the points
ASKER
Actually, MS FlexGrid control works fine (tried it out after I read your suggested), so I might use that.