+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Kiran
    Guest

    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



  2. #2
    zipex
    Guest

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

    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.


  3. #3
    Forum Contributor
    Join Date
    05-03-2004
    Location
    England
    MS-Off Ver
    2003 Excel
    Posts
    118
    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
    Greg.

    "The most overlooked advantage of owning a computer is that if they foul up there's no law against whacking them around a bit."

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1