Hi,

I am trying to make one combo box drive a sum if in a second combo box using the worksheet fuction Sumif.

For some reason I am getting the following error: Object required (Error 424).

My code is as follows:


Private Sub UserForm_Initialize()

Rng1 = Sheets("Sheet1").Range(("A2"), Range("A2")).End(xlDown)
Rng2 = Sheets("Sheet1").Range(("C2"), Range("C2")).End(xlDown)


For i = 1 To 52

Me.ComboBox1.AddItem (i)

Next i

Me.ComboBox1.AddItem "*.*"
Me.ComboBox1 = "*.*"


Smif = WorksheetFunction.SumIf(Rng1, i, Rng2)

Me.ComboBox2 = Smif

End Sub




If anyone can advise where I am gonig wrong I would be very greatful.

Cheers

GM