Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to use answer from combobox selection as listfillrange for s.
I am creating a complex spreadsheed and need to use the answer from the first
combobox as the listfillrange answer on a second combobox. This would allow users of the sheet to select a manufacturer and then the second combobox would let them select the model of equipment made by that manufacturer. It will not accept the answer cell text as the listfillrange entry. It makes that answer cell itself as the listfillrange to be used in the dropdown list. Please help if you have a solution. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to use answer from combobox selection as listfillrange for s.
Not sure exactly what you are trying to do, but believe the below will at
least conceptually get u there. Private Sub ComboBox1_DropButtonClick() ComboBox1.AddItem "aaa", ListIndex = 0 ComboBox1.AddItem "bbb", ListIndex = 1 ComboBox1.AddItem "ccc", ListIndex = 2 End Sub Private Sub ComboBox2_DropButtonClick() ComboBox2.AddItem "fred", ListIndex = 0 ComboBox2.AddItem "frederic", ListIndex = 1 ComboBox2.AddItem "fredy", ListIndex = 2 If ComboBox1.Value < "" Then Dim val As String val = ComboBox1.Value ComboBox2.AddItem val End If End Sub regards, "ModrusAdvillion" wrote: I am creating a complex spreadsheed and need to use the answer from the first combobox as the listfillrange answer on a second combobox. This would allow users of the sheet to select a manufacturer and then the second combobox would let them select the model of equipment made by that manufacturer. It will not accept the answer cell text as the listfillrange entry. It makes that answer cell itself as the listfillrange to be used in the dropdown list. Please help if you have a solution. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combobox listfillrange network | Excel Worksheet Functions | |||
Transpose technique not populating ListFillRange of ActiveX combobox | Excel Discussion (Misc queries) | |||
ComboBox ListFillRange | Excel Discussion (Misc queries) | |||
Strange problem with a combobox and ListFillRange | Excel Discussion (Misc queries) | |||
ComboBox - Changing ListFillRange | Excel Programming |