View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
opieandy opieandy is offline
external usenet poster
 
Posts: 32
Default Exclude Worksheets from Combo Box?

Hi,

The following code was very helpful. Is there any way to exclude certain
Worksheets from being in the Combo Box?


Private Sub UserForm_Initialize()
Dim WS As Worksheet
For Each WS In Worksheets
ComboBox1.AddItem WS.Name
Next
End Sub

Private Sub ComboBox1_Change()
If ComboBox1.Text = "" Then
Exit Sub
End If
Worksheets(ComboBox1.Text).Activate
Unload Me
End Sub