Ok, here is the challenege.

Background: My spreadhseet allows the user to type sentences into
text box. The individual words in the text box are then parsed an
placed in a worksheet in vertical column "A." In vertical column "B"
use vlookup functions that match the word to a number. In another par
of the worksheet, I have essentially a dictionary, where I have abou
6000 individual words listed in a vertical column. Each word i
assigned a discrete number. (00000, 00001, 00002, etc.). So, afte
typing a sentence in the text box (e.g. "I love green eggs and ham")
the spreadsheet would look like thus:

I 32450
Love 43234
Green 34434
eggs 12304
and 00456
Ham 34543

Problem: Sometimes people type words into the text box that are not i
my "dictonary." When that happens, column B will result in "*NID*"
meaning Not-In-Dictionary. (simple IF function)

What I want to do is to have a macro that, when a word is not in th
dictionary, parses the WORD into letters. So if I type i
"serendipity" into the textbox (which is not in the dictionary), th
macro will translate it to " s e r e n d i p i t y", all letters, whic
will be placed in the vertical column (all letters have respespectiv
numners). Thus, the sentence "I want serendipity" would look:

I 43534
want 45676
s 00345
e 01355
r 13544
e 01355
n 76545
d 33434
i 36567
p 35654
i 36567
t 00345
y 33545

Please see previous posts related to the text box parsing:
http://www.excelforum.com/showthread...hreadid=188803

Any help would be appreciate

--
Message posted from http://www.ExcelForum.com