Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combobox drop down
Help please
I have a userform combobox that is linked to other sheet. I want to find a way in Visual Basic so that when an item is selected from this drop down menu, it returns a second list which I have in another sheet. EXAMPLE: I click on the combobox to have the drop down list show. From this drop down list, I want to be able to click on one of the items it has to offer. Now the problem is: Once I click on this Item how do I make it so that it shows a secondary list within the selected drop down item Any Help greatly appreciated |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combobox drop down
As an alternative to VBA, look he
http://www.contextures.com/xlDataVal02.html "N.F" wrote: Help please I have a userform combobox that is linked to other sheet. I want to find a way in Visual Basic so that when an item is selected from this drop down menu, it returns a second list which I have in another sheet. EXAMPLE: I click on the combobox to have the drop down list show. From this drop down list, I want to be able to click on one of the items it has to offer. Now the problem is: Once I click on this Item how do I make it so that it shows a secondary list within the selected drop down item Any Help greatly appreciated |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combobox drop down
hi,
on your form you would need two comboboxes. The first combobox would list your rowsource for the first combobox. you would then need to add code using the combobox1 change event to set the rowsource of the second combobox based on the selection in the first combobox. here i use test data from a project i helped a guy out on several week ago. rowsource of combobox 1 is A2:A5 Private Sub CB1_Change() If Me.CB1.Value = "nag" Then Me.CB2.RowSource = "B2:B5" Else If Me.CB1.Value = "sway" Then Me.CB2.RowSource = "C2:C5" Else If Me.CB1.Value = "runner" Then Me.CB2.RowSource = "D2:D5" Else If Me.CB1.Value = "dilso" Then Me.CB2.RowSource = "E2:E5" End If End If End If End If End Sub There is probable more than one way to do this but this is tested and works. regards FSt1 "N.F" wrote: Help please I have a userform combobox that is linked to other sheet. I want to find a way in Visual Basic so that when an item is selected from this drop down menu, it returns a second list which I have in another sheet. EXAMPLE: I click on the combobox to have the drop down list show. From this drop down list, I want to be able to click on one of the items it has to offer. Now the problem is: Once I click on this Item how do I make it so that it shows a secondary list within the selected drop down item Any Help greatly appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combobox into another combobox | New Users to Excel | |||
combobox changes value | Excel Discussion (Misc queries) | |||
combobox value | Excel Discussion (Misc queries) | |||
combobox | Excel Discussion (Misc queries) | |||
COMBOBOX | New Users to Excel |