why show error couldn't set the list property when run the userform

[Mussa]

Hi

this error causes me the headache sometimes the userform work without problem and somtimes shows "couldn't set the list property .invalid property array index" when run the userofrm in this line

 ComboBox1.List = Sheets("BRANDS").Range("B2", Sheets("BRANDS").Range("B65536").End(xlUp)).Value

Private Sub UserForm_Activate()
    ComboBox1.RowSource = ""
    ComboBox1.List = Sheets("BRANDS").Range("B2", Sheets("BRANDS").Range("B65536").End(xlUp)).Value

End Sub

can any body fix this error ,please?

 

[Mussa]

@Siddharth Rout finally it works greatly
many thanks for fixing the problem