PDA

View Full Version : Auto populate drop down box



austenr
04-25-2007, 01:42 PM
Is it possible to auto populate a drop down in B1 with data in cells A1:A10?

vonpookie
04-25-2007, 01:53 PM
If we're talking data validation list, it's easy. Just set the list source to =A1:A10

Bob Phillips
04-25-2007, 02:52 PM
Or if its a forms or control combobox, bind it to the source using the appropriate property, LinjedRange or ListFillRange.

austenr
04-26-2007, 05:49 AM
What if I have two range of cells?

Bob Phillips
04-26-2007, 05:59 AM
Then you will need to create a Unioned range, or load manually.

austenr
04-26-2007, 06:53 AM
Hi Bob, can you give a sample since I have over 300 possibilities and a doing it manually is not feasable.

Bob Phillips
04-26-2007, 07:00 AM
By manually, I mean looping through each range and AddItem each to the listbox. 300 would be instantaneous.