Okay. Thanks for the many replies. The 'Case Is' and the 'LCase' is working, however, I have to manually run the code to enact changes when the value in the cell is changed. How do I get vba to automatically run when a value is input or the existing value is changed in the active cell?