XL98: TextColumn Property Displays Only the First Column (181814)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q181814 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
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. We are researching this problem
and will post new information here in the Microsoft Knowledge Base as it
becomes available.
REFERENCES
For more information about the TextColumn property, click the Office
Assistant while in the Visual Basic Editor, type How do I use the
TextColumn property? click Search, and then click to
view "TextColumn property."
NOTE: If the Assistant is hidden, click the Office Assistant button on the
Standard toolbar. If Microsoft Help is not installed on your computer,
please see the following article in the Microsoft Knowledge Base:
179216 OFF98: How to Use the Microsoft Office Installer Program
Modification Type: | Major | Last Reviewed: | 9/11/2002 |
---|
Keywords: | kbbug KB181814 |
---|
|