Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Hi all what i want is to be able to:

  1. i have created a cell with a list of values available for selection (this is ok and can do ok)
  2. when i am selecting a value in the above list i would like the list of values to be reduced with matching values as i type....

thanks for your help

share|improve this question
up vote 0 down vote accepted

This has been asked before (no accepted answer yet, though). A data validation drop down can't do this for you. You need to use an active X control, like a Combo box. This requires a bit of programming.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.