Thanks for the help Mandy, however i am confused on how to enter the script. When i enter the script editor, it is blank. I know you can select options but i do not see one that is "CHANGE-Event". When i cycled through all of the scripts related to the text field, i did come across this: form1.Subfo...