Convert a ComboBox to a ListBox?
Posted on 2014-10-03
How would I change the following to be a ListBox instead of a ComboBox, that would show selections as soon as it is opened? Also, is there a way to add something like a suffix to the end of those in the list that are hidden sheet tabs?
I know that I need to chg the object in the userform to a ListBox, but how would the code chg to do this?
Private Sub cmdGoTo_Click()
'Dim bHiddenState As Boolean
If cboSheets.ListIndex <> -1 Then
Worksheets(cboSheets.Value).Visible = xlSheetVisible
Private Sub UserForm_Initialize()
Dim I As Long
For I = 1 To Worksheets.Count