Forms ComboBox - retrieving data

[RacerA]

I am fairly new to this, so please excuse me if this is a stupid question!

I am using comboboxes which were inserted from the forms menu (instead of the controls menu). I am trying to make it so when a certain item from the dropdown is selected, it selects a different sheet.

I have got this to work using a combobox from the controls toolbar, but when my form is run from Excel X Mac, it does not recognise the combobox. (I guess this is because activeX is not supported in the Mac version)

My forms comboboxes are recognised, but I can't get the code to work with them.



The code I use for the NON-Mac version is:

Sub Auto_open()

Sheets("AM Checklist&quot.ComboBox1.AddItem "Select"
Sheets("AM Checklist&quot.ComboBox1.AddItem "Yes"
Sheets("AM Checklist&quot.ComboBox1.AddItem "No"

End Sub

Private Sub ComboBox1_Change()

If ComboBox1.Value = "No" Then
Sheets("Fail&quot.Select
End If

End Sub


Any help would make me a very happy person!