Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a smart textbox that display a list as you start typing in
Hi All,
Is it possible to start displaying items once I start typing in a textbox? For eg, I have a userform connected to access database, Once I start typing in Name text box it displays the result below (something like google search) SO if I type in "A" i get all the names starting with "A" such as: Name: [ A.... ] Aaron Aber Acron If I type in a number, "2" I get the list of phone numbers starting with 2 and so on. Can this be done in VBA? Hope I made it clear. Thanks in Advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a smart textbox that display a list as you start typing in
Yes it is possible,
use the change command of thet textbox to start a search on the "text" of the thext box with the Findcommand in a table ore area succes Toon "sam" wrote: Hi All, Is it possible to start displaying items once I start typing in a textbox? For eg, I have a userform connected to access database, Once I start typing in Name text box it displays the result below (something like google search) SO if I type in "A" i get all the names starting with "A" such as: Name: [ A.... ] Aaron Aber Acron If I type in a number, "2" I get the list of phone numbers starting with 2 and so on. Can this be done in VBA? Hope I made it clear. Thanks in Advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Start typing, possible alternatives appear automatically | Excel Discussion (Misc queries) | |||
Display of Excel file in Winforms in Smart Device Application | Excel Discussion (Misc queries) | |||
How can i display excel file in winforms in Smart Device Applicat | Excel Discussion (Misc queries) | |||
drop down list/typing item from list error | Excel Worksheet Functions | |||
HOW DO I SET UP DROP DOWN CELLS TO AUTO FILL AS I START TYPING IN. | Excel Discussion (Misc queries) |