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:
B:
C:
A:
Code:
ComboBox1.Value = ""
ComboBox2.Value = ""
B:
Code:
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:
Code:
Private Sub ComboBox1_Change()
ComboBox2.Value = ""
End Sub
Last edited: