Hi,
I have a userform with a combobox on it. Upon activation I want it to have
the value from a cell on the worksheet. However sometimes the below code
works and sometimes not:

ComboBox1.Value = Sheets("Brand_Data").Range("A1").Value

I get the "Could not set the Value Property. Invalid proderty value"
message. However when I reset and load the userfrom again it always works...
can anyone make sense of it?

Thanks,
Ozgur