Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Since I am dependent on the wisdom others have provided here, I feel it was
important to contribute my own advice (even if I am not as experienced as other) I think i've found a better solution. I've gone with a for-next loop that compares the user input to every item in the list (which is stored in an array). I have been doing this comparison for every character the user types. It performs better than I expected. However, now will be changing to detecting the Enter key to start my comparison loop by using the following command; onkey (~,MyCompareProcedure) ' note that the Tilde is equivalent to the Enter key. Joe Dunfee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dropdown List That Accepts Other User Input | Excel Discussion (Misc queries) | |||
Combo Box that allows user entry of values not on drop-down list | Excel Discussion (Misc queries) | |||
BRAND NEW USER -: PROBLEMS WITH LIST AND TEXT BOX INPUT | Excel Programming | |||
How can I calculate user input from a combo box into a formula? | Excel Worksheet Functions | |||
Check a user-input value against a list of values? | Excel Programming |