ListBox control, BoundColumn property example
The following example demonstrates how the BoundColumn property influences the value of a ListBox. The user can choose to set the value of the ListBox to the index value of the specified row, or to a specified column of data in the ListBox.
To use this example, copy this sample code to the Declarations portion of a form. Make sure that the form contains:
- A ListBox named ListBox1.
- A Label named Label1.
- Three OptionButton controls named OptionButton1, OptionButton2, and OptionButton3.
Private Sub UserForm_Initialize()
ListBox1.ColumnCount = 2
ListBox1.AddItem "Item 1, Column 1"
ListBox1.List(0, 1) = "Item 1, Column 2"
ListBox1.AddItem "Item 2, Column 1"
ListBox1.List(1, 1) = "Item 2, Column 2"
ListBox1.Value = "Item 1, Column 1"
OptionButton1.Caption = "List Index"
OptionButton2.Caption = "Column 1"
OptionButton3.Caption = "Column 2"
OptionButton2.Value = True
End Sub
Private Sub OptionButton1_Click()
ListBox1.BoundColumn = 0
Label1.Caption = ListBox1.Value
End Sub
Private Sub OptionButton2_Click()
ListBox1.BoundColumn = 1
Label1.Caption = ListBox1.Value
End Sub
Private Sub OptionButton3_Click()
ListBox1.BoundColumn = 2
Label1.Caption = ListBox1.Value
End Sub
Private Sub ListBox1_Click()
Label1.Caption = ListBox1.Value
End Sub
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
https://aka.ms/ContentUserFeedback.
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:Submit and view feedback for