I have a TextBox Control in Access and I'm trying to do something similar in
Excel. In Access I can use the event txbMyTextBox_AfterUpdate() and then
process the full string after the user hits "Enter". But in Excel I just get
the event txbMyTextBox_Change(). So it would seem that I have to process
each character, store the results in a string array and check for the "Enter"
key.

1) Is this correct - or am I missing something?

2) What is the syntax of a string array so that I can read in the data?

3) What is the string compare function that I can use to compare 2 strings?

Thanks for any help you can provide