Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi and thanks in anticipation for helping with this problem....
I have a workbook comprising of 16 worksheets each of which has a Combo Box (from Control Toolbox) which provides links to the other sheets. The code for the Combo Box(es) is: Private Sub ComboBox1_Click() If ComboBox1.ListIndex < -1 Then Worksheets(ComboBox1.Value).Select End If End Sub but what do I need to add to make the Combo Box default to "Select<" (top line) after the user has clicked on the name of the sheet they want to go to next. Apologies if this has already been asked and answered, but I can't find anything that does the trick. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combo box default value | Excel Discussion (Misc queries) | |||
Setting default value for combo box | Excel Programming | |||
Default value in Combo box | Excel Discussion (Misc queries) | |||
Filtered list for Combo Box ListFillRange - Nested Combo Boxes | Excel Programming | |||
default value for combo box | Excel Programming |