ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Thesaurus Find Function (https://www.excelbanter.com/excel-programming/410390-thesaurus-find-function.html)

Qaspec

Thesaurus Find Function
 
Is there a way to create a function that can allow a user to enter a word for
search and if there is no match for that word it will search the thesaurus to
bring back a list of where the synonyms reside in the workbook?

Mark

Jim Cone[_2_]

Thesaurus Find Function
 

Not quite sure what you are after.
However, Excel does not include any kind of built-in Thesaurus feature.

Maybe the free trial of my commercial XL add-in... "Thesaurus for Excel" will be of some help.
Download from the products page at... http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
Portland, Oregon USA
(Excel Add-ins / Excel Programming)



"Qaspec"
wrote in message
Is there a way to create a function that can allow a user to enter a word for
search and if there is no match for that word it will search the thesaurus to
bring back a list of where the synonyms reside in the workbook?
Mark

Qaspec

Thesaurus Find Function
 
I was referring the thesaurus you can use by going to "Tools
ResearchThesaurus:English


I want to know if i can use that research reference to supply and find
alternates to words that users search for.

Example: User uses Find (or some user defined function) to locate the word
shake inside the workbook. The word shake doesn't exist in the workbook but
vibrate does. I'd like to create a function that if no match exists for the
original word, the Research Reference Thesaurus English is opened and all
possible alternatives for the original word are automatically searched for by
Excel. So for my example the function would be able to locate vibrate
anywhere in the workbook even though the user searched for shake.

"Jim Cone" wrote:


Not quite sure what you are after.
However, Excel does not include any kind of built-in Thesaurus feature.

Maybe the free trial of my commercial XL add-in... "Thesaurus for Excel" will be of some help.
Download from the products page at... http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
Portland, Oregon USA
(Excel Add-ins / Excel Programming)



"Qaspec"
wrote in message
Is there a way to create a function that can allow a user to enter a word for
search and if there is no match for that word it will search the thesaurus to
bring back a list of where the synonyms reside in the workbook?
Mark


Jim Cone[_2_]

Thesaurus Find Function
 

It would take a something like a combination of my Thesaurus for Excel and
Find and List programs to achieve that. A major programming endeavor.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Qaspec"
wrote in message
I was referring the thesaurus you can use by going to "Tools
ResearchThesaurus:English


I want to know if i can use that research reference to supply and find
alternates to words that users search for.

Example: User uses Find (or some user defined function) to locate the word
shake inside the workbook. The word shake doesn't exist in the workbook but
vibrate does. I'd like to create a function that if no match exists for the
original word, the Research Reference Thesaurus English is opened and all
possible alternatives for the original word are automatically searched for by
Excel. So for my example the function would be able to locate vibrate
anywhere in the workbook even though the user searched for shake.



All times are GMT +1. The time now is 02:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com