Cannot Implement ListBox Control ColumnHeads Property

• Microsoft Visual Basic for Applications included with: - Microsoft Word 97 for Windows - Microsoft PowerPoint 97 for Windows

SYMPTOMS

When you set the ColumnHeads property for a ListBox control to True, column headings are displayed; however, there is no method for populating the column headings with values in the products that are listed at the beginning of this article.

CAUSE

You must use the ColumnHeads property with the ListFillRange, Control Source, or Row Source properties to populate the headings. These properties are not available in the products that are listed at the beginning of this article.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

The ColumnHeads property works with the Listfillrange property, which is available in Microsoft Excel, or the Control Source and Row Source properties, which are available in Microsoft Access. When you use the Listfillrange property in Microsoft Excel, you can specify a range of values that automatically populate a ListBox control. When you set the value of the ColumnHeads properties to True, each column in the ListBox control contains a heading for the relative column in the range.

For example, in Microsoft Excel, if the ListFillRange property value is A1:C4, the value of the ColumnCount property is 3, and the value of the ColumnHeads Property is True, the column headings are the following:

   Column A | Column B | Column C.