Thanks for that- I got it to work on my PC but when I use another PC via a
vpn connection it doesn't work? Is there some security setting i should watch
out for?
--
Thanks for your help


"Gord Dibben" wrote:

Not with DV list alone.

You have to ustilize a ComboBox in conjunction with the DV dropdown.

See Debra Dalgleish's site for how-to.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP

On Wed, 6 Jan 2010 12:17:02 -0800, David
wrote:

Hi
I have a data validation drop down referencing a list of approx 300 names- I
have to choose about 20 names in 20 rows on a spreadsheet- is there a way of
typing in the first letter and the scrol bar goes down to that point like a
combo box?--
Thanks for your help

.