Userform: Change Combobox list based on a second ComboBox selection

Hi everyone,

I have a number of combo boxes on a userform:

ComboBox1: This has a list of quarters, Q1, Q2, Q3, Q4
ComboBox50 - ComboBox75: This combo boxes should have a list of dates based on the value selected in ComboBox1

On my excel worksheet "Criteria" I have defined cell ranges Q1Dates, Q2Dates, Q3Dates, Q4Dates

What I'm trying to do is:

1. The user selects a quarter in ComboBox1
2. Based on the selection in #1, Comboboxes 50 - 75 change to reflect the excel range list I've shown above. For example

if the user selects Q1 in ComboBox1, then the list in Q1Dates found on the Criteria worksheet will be show up in ComboBoxes 50 - 75.

Any ideas?

Thanks!!

Hi Arkadi

Thanks very much for your reply. I've tried the code you suggested but got the following error:

438
Object Doesn't support this property or method

Private Sub ComboBox1_Change()
If ComboBox1.Value = "Q1" Then
ComboBox50.List = Range("Q1Dates").Values 'error is on this line
End If
End Sub



Any ideas?

Thanks very much for your help.

Addendum:

Oh, I see now what you mean with the mouseup event. I put that in, and I'm no longer getting an error, but the dates are not populating.

Any thoughts?

Thanks!

Haha, you're absolutely right. Thanks very much, Arkadi.