Is it possible to auto populate a drop down in B1 with data in cells A1:A10?
Is it possible to auto populate a drop down in B1 with data in cells A1:A10?
If we're talking data validation list, it's easy. Just set the list source to =A1:A10
Or if its a forms or control combobox, bind it to the source using the appropriate property, LinjedRange or ListFillRange.
What if I have two range of cells?
Then you will need to create a Unioned range, or load manually.
Hi Bob, can you give a sample since I have over 300 possibilities and a doing it manually is not feasable.
By manually, I mean looping through each range and AddItem each to the listbox. 300 would be instantaneous.