Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / February 2008

Tip: Looking for answers? Try searching our database.

Capture typing and immediately search table text?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ed from AZ - 11 Feb 2008 16:04 GMT
(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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.