I have some vba code that prompts the user of Excel spreadsheets for various data items needed to complete tasks on the particular spreadsheet. I have not been able to come up with a way of auto-completing the entries once enough characters are entered to make them unique based upon a range of data entries that I already have available.
If anyone can help I would appreciate it.

Autocomplete entries in inputboxes
ShadowRayz
see previous answer
Chas