Userform in Excel for mac 2013: making dependent combo box issue

[tsiguy96]

I am trying to make a list of 8 combo boxes that all have the same dropdown. the list next to it will all be dependent on waht you selected in the first lift.
Here is the code I am using:

Private Sub UserForm_Initialize()
Dim MyArray As Variant
MyArray = Range("categories")
ComboBox1.List = MyArray
ComboBox2.List = MyArray
ComboBox3.List = MyArray
Dim iCtr As Long
End Sub

Private Sub ComboBox1_Change()
Me.ComboBox9 = ""

Select Case Me.ComboBox1
    Case "Cat1"
        Me.ComboBox9.RowSource = "Cat1"
    Case "Cat2"
        Me.ComboBox9.RowSource = "Cat2"
    Case "Cat3"
        Me.ComboBox9.RowSource = "Cat3"
    Case "Cat4"
        Me.ComboBox9.RowSource = "Cat4"
    Case Else
        'do nothing
End Select
End Sub

but its giving me an error. i get the same dropdown in the first row of boxes, but the second row does not give me a dropdown based on waht i selected, it just throws the debug error. what am i missing? thanks!

[Norie]

Which line of code causes the error and what's the error message?

[tsiguy96]

If I select "Cat2" it debugs this line:

Me.ComboBox9.RowSource = "Cat2"

Error:

Could not set the RowSource property. Invalid property value


could this have anything to do with Office for Mac not recognizing it?

[Norie]

Have you checked the named ranges?