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
.