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.
Printable View
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.