View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Joe Dunfee Joe Dunfee is offline
external usenet poster
 
Posts: 10
Default Determing if user input is on list in Combo Box

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