XL97: TextColumn Property Displays Only the First Column (165644)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
This article was previously published under Q165644

SYMPTOMS

When you set the TextColumn property for a ComboBox or ListBox control on a UserForm in a Visual Basic for Applications macro, Microsoft Excel may display the first column in the range of data instead of the column that you specify.

WORKAROUND

To work around this problem, set the ColumnWidths property to 0 (zero) so that the column you want to display is the first column in the range of data that has a column width greater than 0. For example, if you want to display the second column in the list but return a value from the first column of the list, use the properties that are listed in the following table. 
   Property        Value
   ---------------------
   BoundColumn         1
   ColumnCount         2
   ColumnsWidths       0
   TextColumn          2

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

The TextColumn property identifies the column in a ComboBox or ListBox that is displayed. Values for the TextColumn property range from -1 to the number of columns in the list. For example, the first column is 1, the second column is 2, and so on. Setting the TextColumn property to 0 displays the Listindex values. Setting the TextColumn property to -1 displays the first column that has a ColumnWidth greater than 0.

For more information, please see the following article in the Microsoft Knowledge Base:

165570 How to Use the TextColumn Property

REFERENCES

For more information about the TextColumn property, click the Index tab in Visual Basic for Applications Help, type the following text

textcolumn

and then double-click the selected text to go to the "TextColumn Property" topic.
Modification Type:MajorLast Reviewed:10/22/2000
Keywords:kbbug KB165644
©2002 Microsoft Corporation. All rights reserved.