Capture typing and immediately search table text?

[Ed from AZ]

(With Word 2000) I would like to build a program that would allow me
to type on a keyboard and use those letters to automatically search
columns in a table and return the first string that matches that
letter sequence.

I will have four columns. The lists will be sorted alphabetically.
I'm thinking of putting this in a form. So I type "E" and the four
text boxes on the form (one for each table column) show the first text
entry the starts with "E" with no other key press. Then I type "s"
and get entries that start with "es". Letter case won't be
considered, and no numbers will be involved. If no entry matches, I
may have the text box change color or disable.

The table entries with be hyperlinks to documents. When I see the
hyperlink I want come up, I will type 1, 2, 3 or 4 for the text box I
want and the doc will load up.

Or am I dreaming too hard? 8>/

Ed

 

[Helmut Weber]

Hi Ed,

google for:

type ahead
find as you type
search as you type

though you'll mostly find database stuff.

Basically you need nothing but a userform
with a textbox for input with a change-event.

Private Sub TextBox1_Change()
MsgBox Me.TextBox1.Text
End Sub

Depending on the text you start your action.

HTH








--

Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Vista Small Business, Office XP