position in List of Values

[hsauve]

Please help...
I use and create large spreadsheets using Excel 2010 and I have used the data validation tool to insert lists of values to select from. The lists sometimes are long and users don't like scrolling through them to find the value they want. I want to know if there is an option that allows users to type the first character to jump to that section of the list instead of scrolling or if there is any other option that would speed up this process or make it easier.

 

[Jerry Sullivan]

Welcome to the Board,

The Contextures site has some instructions on how to simulate this using a dropdown combobox. They have an example you can download too.

http://www.contextures.com/xlDataVal11.html

 

[hsauve]

Thank you Jerry - I really appreciate the help. I will give it a try.

 

[hsauve]

Thank you again Jerry

I managed to write code of my own using the sample that I reviewed from your post. Thanks for steering me in the right direction. It works perfectly now and I added a few other enhancements.

Holly

 

[Jerry Sullivan]

Hi Holly, I'm happy to hear that this helped.
Thanks for providing the feedback.