problem moving focus combobox to another

[Scoobidoo]

Hi,

I've about 140 comboboxes and a user should choose a value in each combobox.
In order to make input easier I'd like to drop-down automatically the next combobox after the user has chosen a value in the previous one.
For a start I tried it with 2 comboboxes but Excel crashes always when trying to move the focus.

Does anyone have an idea how to drop-down automatically the next combobox?
My not working code:

Private Sub Worksheet_Activate()
     Me.ComboBox1.DropDown
End Sub

  
Private Sub ComboBox1_Change()
    If ComboBox1.ListIndex > -1 Then
          Me.ComboBox2.DropDown
    End If
End Sub

 

[Scoobidoo]

@ mikerickson

Thank you for testing my code.

Do I understand you well? Does the combobox2 open automatically after you 've chosen a value in combobox1?

If so, which version of Excel do you use?

I've tried "Combobox2.setfocus" but at execution I get error 438 "property not supported"

 

[mikerickson]

The code I provided is for user form controls. ActiveX isn't supported on my Mac. My guess that it would work for ActiveX was apparently wrong.