Hyperlinking to a Glossary

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


I have several rows of cells containing sentences, like 'the dog ran
after the cat). On another ***, I have a glossary of terms with
Column A giving the term, and column B the meaning (eg (Col A) Dog (Col
B) Four legged animal that dislikes cats).

I want to identify in each of the cells within the rows, that contain
the sentences, which words (if any) are in the glossary, and then
hyperlink them to one another (the individual words, not the whole
cells), or at the least, underline the words so the reader knows their
meaning is explained in the glossary.

I think this is a VBA problem but not sure.

Thanks for your help in advance.


--
AndrewB
------------------------------------------------------------------------
AndrewB's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31994
View this thread: http://www.excelforum.com/showthread.php?threadid=517261

.

Quantcast