Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching in a user form / List box
Hello, I have created a user form with msforms and a long long list of names (authors, to be exact) in a list box to choose from. Now, if I'm looking for, say, "Smith", I type "S" which takes me to the first author whose name starts with "S", say Samson. What I would like now is that if I type in "M" now that it takes me to the names starting with "Sm" and so on. This kind of search would save a LOT of time. Instead, typing "M" takes me to the M-authors, of course. Is there a way to implement this? Also, this kind of search has a special name - I forgot it right now...can anybody help me out? It's been bugging me for weeks and I'd be very grateful if anybody could give me a hint. Thanks, Max -- Idokras ------------------------------------------------------------------------ Idokras's Profile: http://www.excelforum.com/member.php...o&userid=28873 View this thread: http://www.excelforum.com/showthread...hreadid=486209 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching in a user form / List box
When you're in the VBE, select your listbox on your userform.
Hit F4 to see the properties window Look for MatchEntry There's a fmMatcheEntryComplete that sounds like what you want. Idokras wrote: Hello, I have created a user form with msforms and a long long list of names (authors, to be exact) in a list box to choose from. Now, if I'm looking for, say, "Smith", I type "S" which takes me to the first author whose name starts with "S", say Samson. What I would like now is that if I type in "M" now that it takes me to the names starting with "Sm" and so on. This kind of search would save a LOT of time. Instead, typing "M" takes me to the M-authors, of course. Is there a way to implement this? Also, this kind of search has a special name - I forgot it right now...can anybody help me out? It's been bugging me for weeks and I'd be very grateful if anybody could give me a hint. Thanks, Max -- Idokras ------------------------------------------------------------------------ Idokras's Profile: http://www.excelforum.com/member.php...o&userid=28873 View this thread: http://www.excelforum.com/showthread...hreadid=486209 -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching in a user form / List box
Thanks, worked like a charm! Saves me a lot of time, so thanks. -- Idokras ------------------------------------------------------------------------ Idokras's Profile: http://www.excelforum.com/member.php...o&userid=28873 View this thread: http://www.excelforum.com/showthread...hreadid=486209 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Form - Get Data From Drop List | Excel Discussion (Misc queries) | |||
Searching by an User Form | Excel Worksheet Functions | |||
User Form List Box | Excel Programming | |||
User Form / List Box | Excel Programming | |||
Creating a list box in a user form | Excel Programming |