Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Labels as Combo Box Selections
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo Box Showing Date Selections | Excel Discussion (Misc queries) | |||
Counting Combo Drop Down Box Selections | Excel Worksheet Functions | |||
Enter values in a column with combo box selections | Excel Programming | |||
Can List or Combo Box have multiple selections? | Excel Worksheet Functions | |||
Multiple Selections in a Combo Box??? | Excel Programming |