Cantonalives
Member
Hiya,
I am trying to change the listfillrange on combobox 1, but alas the code does not seem to work. I would like it change on the way in to excel but for now I am just trying to get the macro to work. Sadly I am getting an 'object required' message....
Thanks for any assistance
-CL
I am trying to change the listfillrange on combobox 1, but alas the code does not seem to work. I would like it change on the way in to excel but for now I am just trying to get the macro to work. Sadly I am getting an 'object required' message....
Code:
Sub ComboBox1_Change()
ComboBox1.ListFillRange = "list"
End Sub
Thanks for any assistance
-CL