![]() |
|
![]() |
|
Thread Tools | Display Modes |
|
#1
|
||||
|
||||
![]() Scrolling through a sorted list would hardly take much longer than typing. That said, what you require if you're going to allow free input is some form of error-trapping. For that, you could use the keypress event to test each character as it's input to prevent invalid strings being input, or you wait till the string has been then test for its presence amongst the other entries and, if not found, delete the entry and return the user to the combobox instead of continuing with the processing.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Value of Combobox in other userform | Vibov | Excel Programming | 4 | 11-19-2015 04:12 AM |
![]() |
wpryan | Word VBA | 3 | 07-17-2015 01:44 AM |
![]() |
ADubin | Excel Programming | 3 | 02-08-2015 04:57 AM |
Mail merge, text boxes, and two documents per sheet! | MelissaAnnie | Mail Merge | 2 | 09-24-2014 03:46 PM |
Condensing a spread sheet | hawkeyefxr | Excel | 4 | 08-22-2012 05:17 AM |