Jump to section in Validation List

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a cell with Validation that displays a List with 1000 entries in it. How can I make it so that when the user types an 'h', it jumps to the first entry in the List that starts with an 'h' so the user doesn't have to scroll all the way down to the h's ?

Thanks in advance !
 
Sorry, that's not possible in a data validation list. (a list of this type is frequently not a sorted list)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide column based on data validation 0
Excel JUMP FROM SEARCH BAR TO RESULT 3
macro listing subfolders from selection of mainfolders 1
Conditional Validation In Excel 1
Couple subs need help with 2
Active cell is to jump from one cell to another when conditions are met 2
Data Validation List (conditional) 2
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1

Back
Top