Jump to the item in a list as the first letter is pressed

K

Kiran

I have couple of large lists with alphabetised data. Is it possible to have
intellisense, like if P is pressed on the keyboard, it should jump to P, if H
then jump to first name with H as the first letter, like that. It does not
happen with the lists I have(by default)?Is this possible?

Thnx
 
Z

zipex

Here is one way you could try, but it will go there and filter at th
same time (you may or may not want it) :shock:
If your list is in contiguous rows and columns, meaning no blank rows
no blank columns, then setup autofilter. The dropdown list accept
first letter
Autofilter is setup using toolbar's Data, Filter, check autofilte
after you placed the cursor in the headings of your table. Not onl
you'll be able to jump to a letter you want, but you will be able t
filter out the desired rows. The address of the cell then appears i
the address box
 
G

greg7468

Hi,
I don't know whether this is what you are looking for but if you pu
the following code in.
Now when you put the first letter in B1 it will automatically jump t
that row.

HTH.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$B$1" Then Exit Sub
Set x = Columns(1).Find(Target.Value)
Application.Goto Range(x.Address), Scroll:=True
End Su
 
Top