title: VBA Get Combobox to 'suggest' an option
body: <p>I am relatively new to VBA and I am trying to solve a problem working with a userform in Excel 2010.</p>
  
  <p>I am writing a pseudo spell checker that validates words against a list.  The unknown word is presented in a text box and the list of allowed words is in a combo box below.  I would like the combo box to present a 'suggestion' based on the unknown word.  i.e. the unknown word is "Excavation" and one of the allowed words in the combo box is "Excavate".  I would like the combo box to suggest the term "Excavate".  My problem is that autocomplete doesn't offer a suggestion because the unknown word is longer than the allowed word. </p>
  
  <p>My thought on solving the problem is to do the following:
  - Parse the unknown word into a character array.
  - Add the characters one at a time to the combo box text property and allow autocomplete to run.
  - As soon as autocomplete stops working, remove one character and insert the word that autocomplete suggests.</p>
  
  <p>My problem is I cannot find anything to tell me once auto complete has stopped working.</p>
  
  <p>Any thoughts, suggestions, or alternate approaches welcome.</p>
  
  <p>Thanks in advance,</p>
  
  <p>Will</p>