Hi

I got two drop down lists on a worksheet. When I click the drop button
on the second list I got the following error mesage" Object doesn't
support this property or method!" and I think the error is about
RowSource property .(please refer to the below code)

Private Sub ComboBox3_DropButtonClick()

If Worksheets("Sheet1").ComboBox2.Value = "AMERICAS" Then
Worksheets("Sheet1").ComboBox3.RowSource = "List!A7:A8"

ElseIf Worksheets("Sheet1").ComboBox2.Value = "ASIA PACIFIC" Then
Worksheets("Sheet1").ComboBox3.RowSource = "List!A10:A12"

End If

Both comboboxes are on Sheet1 are populated with the data from the
sheet called "List" from the above specified ranges.

Could anyone help me with an advice?

Thank you in advance
Cristian



End Sub

try

..ListFillRange instead of .rowsource.

(.rowsource is used in a userform, though)

Cristian wrote:

Hi

I got two drop down lists on a worksheet. When I click the drop button
on the second list I got the following error mesage" Object doesn't
support this property or method!" and I think the error is about
RowSource property .(please refer to the below code)

Private Sub ComboBox3_DropButtonClick()

If Worksheets("Sheet1").ComboBox2.Value = "AMERICAS" Then
Worksheets("Sheet1").ComboBox3.RowSource = "List!A7:A8"

ElseIf Worksheets("Sheet1").ComboBox2.Value = "ASIA PACIFIC" Then
Worksheets("Sheet1").ComboBox3.RowSource = "List!A10:A12"

End If

Both comboboxes are on Sheet1 are populated with the data from the
sheet called "List" from the above specified ranges.

Could anyone help me with an advice?

Thank you in advance
Cristian



End Sub

--

Dave Peterson