Hi! I have an issue with an excel-based tool that i am developing. There is a list of about 400 chemicals that should be available to a user to choose from (now in a drop-down menu, but not vital). As those are chemicals, users often are trying to enter the names as they know them and not exactly as they are present in the list. Client wants a sort of a fuzzy search for them. As ideally imagined: put cursor into the cell, type the name of the chemical, and a one/two/some the most closely matching appear as an option to enter. The trick is that the tool is to be distributed in many different companies with different policies, so the client doesn't want to use marcros or add-ins that need administrator rights to install. Any ideas anyone please? would be highly appreciated! =)
Bookmarks