hi guys,

pretty new to the programming of excel and would like to ask bout this
question.

Here's what i have done so far:

i have a two comboboxes (i.e. ComboBox A and B)
say i have a few values in ComboBoxA and when a user selects a certain
value, ComboBoxB would change it's ListFillRange according to the value
selected in ComboBoxA. However, the values in ComboBoxB would not update
itself unless i manually change the values in ComboBoxB.
anyone can help me in terms of how to refresh the ListFillRange in ComboBoxB
when a selection in ComboBoxA is changed?


my code:

Private Sub ComboBox2_Change()

If ComboBox1.Value = "A" Then
ComboBox2.ListFillRange = "AList"

Else
ComboBox2.ListFillRange = "BList"

End If

End Sub



Thanks in Advance,

Melvin