Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Jump to data in a list as first letter is pressed | Excel Discussion (Misc queries) | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
How select an item in a list box | Excel Worksheet Functions | |||
Refresh a Validation List? | Excel Discussion (Misc queries) | |||
Selecting an Item from a List and getting a different item to pop. | Excel Worksheet Functions |