I have a combobox on a userform, that I want to have the cbo pick up a list off of one of the worksheets instead of .add item for 300 items.

I went to the RowSource property for the combobox and put

=Sheet2!A100:A400

And it gave me an error that said

could not set the RowSource property. Invalid property value.


Could someone please help or clarify where I am stuck at.

Thanks

Josh