Auto populate drop down box

[austenr]

Is it possible to auto populate a drop down in B1 with data in cells A1:A10?

[vonpookie]

If we're talking data validation list, it's easy. Just set the list source to =A1:A10

[Bob Phillips]

Or if its a forms or control combobox, bind it to the source using the appropriate property, LinjedRange or ListFillRange.

[austenr]

What if I have two range of cells?

[Bob Phillips]

Then you will need to create a Unioned range, or load manually.

[austenr]

Hi Bob, can you give a sample since I have over 300 possibilities and a doing it manually is not feasable.

[Bob Phillips]

By manually, I mean looping through each range and AddItem each to the listbox. 300 would be instantaneous.