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 array and then perform a first name and last name match within the array. If multiple names match I'd like to open a user form and allow the user to choose from the smaller list of names, then have that name written to the spreadsheet. My question: What construct is available in the user form that would best suit this purpose? Can I arrange a dropdown, for instance? Any ideas appreciated- thanks. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
