G
Guest
Guest
How do you reference the text or values in a List Box. i.e. suppose I want to unhide a sheet if a box is checked or highlighted in the list box, how do I reference the value and what function do I use (i.e. ListBox_Change, ListBox_Click, etc...).
For a combo box I would write
Private Sub ComboBox_Change()
If ComboBox = "Argentina" Then
Sheets("Argentina").Visible = True
End If
End Sub
How do I do this same thing with a list box. I want to be able to select multiple countries and unhide the appropriate sheets. Thanks
For a combo box I would write
Private Sub ComboBox_Change()
If ComboBox = "Argentina" Then
Sheets("Argentina").Visible = True
End If
End Sub
How do I do this same thing with a list box. I want to be able to select multiple countries and unhide the appropriate sheets. Thanks