I have a file that caters to a coddled group that can't be bothered to think much.

The file has a userform that allows them to input a name. I need to find an associated ID number for the name from a database. the problem is names are being missspeled . I can't use validation because when the name is misspelled the user can't be bothered to scroll through the huge list of names.

I'm wondering if there is code I could use that would work something like when you misspell in a google search. It would look at the input, then compare to the database and suggest which names the user might have meant.