Worksheet Labels as Combo Box Selections
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
"pdberger" wrote:
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.
|