How would I assign an Excel range on a spreadsheet to a combobox, so anything in the range shows as entry in the dropdown ?

I know in VBA I can use the .Rowsource property, but in VB I don't appear to have this option.

Any ideas anyone ?

Thanks.