Object Required error with ActiveX Combobox

[kgartin]

Why do codes A & B below give me an Object Required (424) error (A is assigned to a button, B obviously fires on WB open) but C works without any issues?:

A:

ComboBox1.Value = ""
ComboBox2.Value = ""

B:

Private Sub Workbook_Open()


Dim ROWC As Integer


ROWC = Worksheets("JOB NAMES").Cells(Rows.Count, 2).End(xlUp).Row


ComboBox1.List = Worksheets("JOB NAMES").Range("B3:B" & ROWC).Value


End Sub

C:

Private Sub ComboBox1_Change()


    ComboBox2.Value = ""


End Sub

 

[Fluff]

Assuming the the combos are on a sheet, code C works because it's in the relevant sheet module.
code B (and possibly A) fails because you have not qualified the combo with the sheet name

 

[kgartin]

Yep that's it. Thanks for the response!

 

[Fluff]

You're welcome & thanks for the feedback