Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching for closest matches using wildcards or range.find
Thanks very much for the help Ed. I think I would like to explore your
advice on using range.find...I'm just not sure how to go about doing that. Like I said, I am still in the learning process and that is one area of VBA that I haven't explored. Unfortunately, I don't find the help files found in excel and vba very helpful. Could anyone please try to advise me on using range.find to accomplish what I'm trying to accomplish? Here is what I would like to do(the simplified version). I have a textbox and a command button on a worksheet. When the user types in a particular word, found in a list on another sheet, I would like the attached macro to return all of the closest matches. So if the user typed in poetry, and accidently spelled it wrong, when they click the "search" command button it will check the list where the entry is supposed to be contained and find one or more matches that are close. This will then be populated into a listbox that they can choose from. I would be very elated if I could get this to work. Thank you Kevin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching for closest matches using wildcards or range.find
Check out the recent thread "wildcard" in this NG.
NickHK wrote in message oups.com... Thanks very much for the help Ed. I think I would like to explore your advice on using range.find...I'm just not sure how to go about doing that. Like I said, I am still in the learning process and that is one area of VBA that I haven't explored. Unfortunately, I don't find the help files found in excel and vba very helpful. Could anyone please try to advise me on using range.find to accomplish what I'm trying to accomplish? Here is what I would like to do(the simplified version). I have a textbox and a command button on a worksheet. When the user types in a particular word, found in a list on another sheet, I would like the attached macro to return all of the closest matches. So if the user typed in poetry, and accidently spelled it wrong, when they click the "search" command button it will check the list where the entry is supposed to be contained and find one or more matches that are close. This will then be populated into a listbox that they can choose from. I would be very elated if I could get this to work. Thank you Kevin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find closest match and return next highest number in range | Excel Discussion (Misc queries) | |||
how do i find multiple matches of one data item in an excel range | Excel Discussion (Misc queries) | |||
Find text in a string that matches value(s) in a range | Excel Programming | |||
Find the POSITION IN A RANGE of text in a string that matches value(s) in a range | Excel Programming | |||
Searching a list using wildcards | Excel Programming |