Dynamic Combo Box
 

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

There are two Combo Boxes in my spreadsheet. The first one is called "drop down 2" which has two options "Investment" or "Withheld". Basically, when user chooses "Investment" in the first combo box, the second combo box will appear to have choices between "High" or "Low". On the other hand, if the user chooses "Withheld" on the first combo box, the second combo box will then have choices between "One" or "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 new 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 my error?

Consider using data validation instead, and take a look at this site for
guidance

http://www.contextures.com/xlDataVal02.html




"benjarfer" wrote:


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

There are two Combo Boxes in my spreadsheet. The first one is called
"drop down 2" which has two options "Investment" or "Withheld".
Basically, when user chooses "Investment" in the first combo box, the
second combo box will appear to have choices between "High" or "Low".
On the other hand, if the user chooses "Withheld" on the first combo
box, the second combo box will then have choices between "One" or
"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 new
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 my
error?


--
benjarfer

"benjarfer" дÈëÓʼþ
...

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

There are two Combo Boxes in my spreadsheet. The first one is called
"drop down 2" which has two options "Investment" or "Withheld".
Basically, when user chooses "Investment" in the first combo box, the
second combo box will appear to have choices between "High" or "Low".
On the other hand, if the user chooses "Withheld" on the first combo
box, the second combo box will then have choices between "One" or
"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 new
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 my
error?


--
benjarfer