So I created some VBA to loop through either a direct manually input data validation set or a named range and automatically pick the entry that matches the string a user types in.
For example, say you had a list of U.S. state names and the user starts typing New y and presses enter, it would...