Re: $$Excel-Macros$$ Fuzzy name match- output from userform

2011-10-14 Thread Sam Mathai Chacko
My take would be to have a list-box instead of a dropdown. Have a multi-select listbox, and give an option to the user to select the desired list of names. Regards, Sam On Fri, Oct 14, 2011 at 7:09 AM, DaveO wrote: > I have a scenario in which a user needs to perform a "fuzzy" match > between

$$Excel-Macros$$ Fuzzy name match- output from userform

2011-10-13 Thread DaveO
I have a scenario in which a user needs to perform a "fuzzy" match between a name and a variation of that name in a list about 4500 names long. For example, the user may be looking for "Smith, John" but needs to match to "Smith,John Jr" in the longer list. My plan is to write the long list to an a