Dropdown list with more than eight items

**romperstomper** · 10-05-2009, 08:30 AM

The DV dropdown can have 70 rows (and a lot more) it's just that only 8 are visible at one time - you have to scroll to see the others. To be honest, I don't see what benefit you would get from having all 70 visible at once. (though I can see the advantage of the autocomplete, which is tricky to implement with DV.)

**DonkeyOte** · 10-05-2009, 08:36 AM

Originally Posted by romperstomer

It is a good name though...

Yes, it is... credit to whomever it was that suggested it...

... not getting me much joy on the CV front though !

Originally Posted by romperstomper

...though I can see the advantage of the autocomplete, which is tricky to implement with DV

R, you imply it is "possible" then to implement AutoComplete with Validation - can you demo ?

**romperstomper** · 10-05-2009, 08:46 AM

Originally Posted by DonkeyOte

Yes, it is... credit to whomever it was that suggested it...

... not getting me much joy on the CV front though !

yes, it's one advantage of using a real name occasionally!

R, you imply it is "possible" then to implement AutoComplete with Validation - can you demo ?

Not strictly autocomplete, but you can filter the validation list based on what is typed - see here for example. In all honesty I would probably use userform for this instead though, if there were so many items as to require this!

**DonkeyOte** · 10-05-2009, 08:47 AM

hmm... unfortunately I'm getting malware warning on that link (Chrome)

**johnlovesbeer** · 10-05-2009, 08:54 AM

Thanks Guys, got the scrolling dropdown in DV working a treat! Brilliant!

Once again, thanks for all the help. I will leave the thread open for a little while before I mark it as solved in case you solve the auto-complete issue!

Cheers,
JLB.

**romperstomper** · 10-05-2009, 08:55 AM

It's a link to Colo's junk room, so I'm not sure what the issue is. (I have seen it before, but just ignore it, since I don't download or run anything from there.)

**johnlovesbeer** · 10-05-2009, 08:42 AM

Hi Romper, maybe I'm being a bit thick here! How do I create a scrolling dropdown that can handle 70 rows in DV? I can't find any options to do so! It's probably something simple that I can't see.

Thanks, JLB.

**DonkeyOte** · 10-05-2009, 08:43 AM

If you use the file I provided to demo the DV...

in a cell insert a Validation List - set Source to be =Options

You should now see a List in the cell containing the 75 options, 8 will display but you can scroll.