Navigating in big list

  • Thread starter Thread starter Torstein S. Johnsen
  • Start date Start date
T

Torstein S. Johnsen

In a worksheet I have hundreds of rows with names (alfabetically sorted). Is
there a way to get functionality like in Windows explorer? I like to write a
letter D and the first row with name starting on D becomes the selected cell
(sorry about my english)?

Torstein
 
Torstein,

I assume your list has multiple columns, so putting a row
of hotspots at the top isn't going to work.

How about splitting the screen and having a row of cells
at the top, and the list beneath. This would allow you to
use the worksheet change event to test:

Which cell is the activecell in the top part of the
screen, and then scroll the bottom section of the window
to the corresponding entry in the corresponding column.

Say your list consists of
______________________________________________
| X | | |
______________________________________________
Adam
Arthur
Brian
Betty
Bertha
Charlie
Charlotte
Clarice
Doug

Where the X is, you type "C", use the Worksheet_Change
event to determine the activecell, then jump to the list,
iterate through the list until you find the match and
bring it to the top row of the bottom area of the window,
jump back to the top area (the cell containing X) enter
edit mode and wait for a key press, if a further key is
pressed, say "L", you now do the same again searching
from the first match, looking for "CL".

Does this help?

Steve
 
There is no direct support for it - but you could put up a userform and use
the change event in a textbox to position the activecell, or you could load
the data in a combobox/listbox and use the built in capability of that
control to do it.
 
Back
Top