Data Validation with selection

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

Can Excel 2003 be set up, without VBA, to do Data Validation from a range of
cells so that if the person type in the first few letters of the range the
pointer moves down the list to those cells to start the selection process?
Example of "la" moves to Lanata and doesn't start at Alyssum for the
selection. If 2003 does not do this, can 2007 accomplish it?
I have looked on Contextures' and J-walk websites without success.

Thanks,
 
Thanks for the response but I am not looking for autocomplete. I would like
to type in the first few characters and then press the spinner to have it go
to that point in the list rather than the first item in the list. If I typed
in "zz" or "300" it would open the list to the nearest group of "zz" or
"300" not start at the beginning of the alphabet or numbers. I don't think
it can do it but thought I would ask.
Thanks again for the response and sorry for not being clearer.
Lee Coleman
 
You have just described "autocomplete".

Re-phrase and re-post if you are not looking for autocomplete.

BTW.......there is no spinner attached to a DV list cell.....only a drop-down
arrow.


Gord
 
Back
Top