Dynamic Combo Box

B

benjarfer

I really need help on creating a Dynamic Combo Box, please.

There are two Combo Boxes in my spreadsheet. The first one is calle
"drop down 2" which has two options "Investment" or "Withheld"
Basically, when user chooses "Investment" in the first combo box, th
second combo box will appear to have choices between "High" or "Low"
On the other hand, if the user chooses "Withheld" on the first comb
box, the second combo box will then have choices between "One" o
"Two".

I have spent ages on getting this to work, but I am still struggling
this is my work so far.

Sub Deduct()
'shows user dropdown2 results
If DropDown2.Value = "Investment" Then
dropdown4.Visible = True
dropdown4.ListFillRange = "c3:c4"
Else
If DropDown2 = "Withheld" Then
dropdown4.Visible = "c6:c7"
End If
End If
End Sub

I can't spot any errors in it myself, probably because I am only a ne
user in excel. But the following message came popping up,:

Runtime error '424':
Object Required

I don't understand? What kind of objects are required? Can you spot m
error
 
Top