(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 - 11 Feb 2008 16:17 GMT
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