ListBox items are units of code in VBscript applications that allow you to display a list of items where multiple entries can be selected. Each ListBox item in a Microsoft Excel macro (VBA file) lets you define the number of columns that will be used for the ListBox information. You can quickly add this to your ListBox by modifying its "ColumnCount" attribute.
- Skill level:
- Moderately Easy
Other People Are Reading
Locate your ListBox definition. For example, if your ListBox is named "ListBox8," navigate to the first entry for "ListBox8" in your script file.
Modify the "ColumnCount" attribute of the ListBox. Type "ListBox8.ColumCount = 5" to give five total columns to the ListBox.
Save your program by clicking the "Save" button on the top of the Excel sheet.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for