Knowledge Base

OFF97: Cannot Implement ListBox, ComboBox Control ColumnHeads Property

Article ID: 164343

Article Last Modified on 1/19/2007

Microsoft PowerPoint 97 Standard Edition
Microsoft Word 97 Standard Edition
Microsoft Outlook 97 Standard Edition
Microsoft Outlook 98 Standard Edition

This article was previously published under Q164343

SYMPTOMS

When you set the ColumnHeads property for a ListBox control or a ComboBox control to True, column headings are displayed. However, there is no method for populating the column headings with values, for 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 that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

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

For example, in 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.

REFERENCES

For more information about getting help with Visual Basic for Applications, please see the following article in the Microsoft Knowledge Base:

ARTICLE-ID: 163435
TITLE : VBA: Programming Resources for Visual Basic for Applications

Additional query words: wordcon word8 word97 ppt8 8.00 8.0 vb vbe vba ol97 ol98 OFF97

Keywords: kbbug kbdtacode kbpending kbprogramming KB164343