View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default Selecting from a drop down list

Hi,

Please take a look at question 44 of the following link -
http://ashishmathur.com/replies.aspx

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Scott W" <Scott wrote in message
...
I have a drop down list that has approx 120 choices. Is there a way to
type
in a letter and have the highlight jump to the first name with that
letter?

Example: I want to select the name "Jake"

Can I type in the letter "J" in the drop down list and have it jump to the
nearest name starting with "J"

Thank you for your help in advance!