Things you can do with a multicolumn ListBox or ComboBox
To control the column widths of a multicolumn ListBox or ComboBox, you can specify the width, in points, for all the columns in the ColumnWidths property. Specifying zero for a specific column hides that column of information from the display.
If you want to hide all but one column of a ListBox or ComboBox from the user, you can set the ColumnWidths of the other columns to zero and identify the column of information to display by leaving its ColumnWidths property set to the default value and by using the TextColumn property. When the user selects a row, the Text property of the control is set to the value of the column identified by the TextColumn property. In a combo box, the system displays the column designated by the TextColumn property in the text box portion of the control.
Similarly, you can control which column of values is used for the control when the user makes a selection by specifying the column number in the BoundColumn property.
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for