Worksheet Labels as Combo Box Selections

[pdberger]

Good afternoon --

I would like to set up a combo box using the labels of the worksheets as the
options from which the user selects. So, if I had a contiguous set of
worksheets -- Smith, Jones, Thompson, for example -- how could I do that?

Can anyone help with how to do that?

Thanks in advance.

 

[reklamo]

If you are using a UserForm and a ComboBox in the UserForm assign the
following macro to the user form:

Private Sub UserForm_Initialize()
For Each ws In ActiveWorkbook.Worksheets
ComboBox1.AddItem ws.Name
Next
End Sub

regards
reklamo