Hi, I have a form with several ActiveX Combo Boxes. I also have some check
boxes. When one checkbox value is true, I want the combobox to default to a
value, but when I put this code in, I get and "Object Not Defined" error
message.

Private Sub CheckBox6_Click()

If CheckBox6.Value = True Then

Worksheet.DropDown1176.Value = a89

End If

End Sub


Keep in mind I know Access VBA, but my Excel VBA skills are limited.

Thanks,
Harry