i have a string called fs. on certain trigger in textbox tb1, this string fs gets entered in range("a1"). and same fs gets added to the textbox. now when i make certain enteries in same textbox(another event trigger) it should overide everything and change the value of fs to what i want .

i figured that i can trigger an event on if the cell value a1 changes then from now on fs=whatever ... until i press reset. something like that.

CAn you Please help me...Its URGENT>