Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I created a combobox that accepts a dynamic list. The problem is:
when I program the Case code for the event Combobox_change I am faced with the missing code for the new cases ( added items in the dynamic list ) Let me expand: Private Sub ComboBox1_Change() Select Case ComboBox1.Text Case ("item1") Worksheets("item1").ShowDataForm Case ("item2") Worksheets("item2").ShowDataForm Case Else End Select Now I have the new "item3" in the combobox but no code to execute the selection The needed code is: case ("item3") Worksheets("item3").ShowDataForm How can I can PROGRAM adding these lines to my CASE section ???? You help will be greatly appreciated ...as allways |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can a Combobox in a Userform access multiple dynamic tables | Excel Discussion (Misc queries) | |||
.AddItem list and populating combobox with created list | Excel Discussion (Misc queries) | |||
How Do I Load a ComboBox From a Dynamic Range | Excel Discussion (Misc queries) | |||
Dynamic ComboBox | Excel Programming | |||
Dynamic update on ComboBox | Excel Programming |