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

• Microsoft Forms reference
• Microsoft Forms conceptual topics

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.