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

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

Here is one way you could try, but it will go there and filter at the
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 accepts
first letter.
Autofilter is setup using toolbar's Data, Filter, check autofilter
after you placed the cursor in the headings of your table. Not only
you'll be able to jump to a letter you want, but you will be able to
filter out the desired rows. The address of the cell then appears in
the address box.

Hi,
I don't know whether this is what you are looking for but if you put
the following code in.
Now when you put the first letter in B1 it will automatically jump to
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 Sub


--
greg7468


------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=382960