I have some TextBoxs (ActiveX) in my Sheet which linked to another sheet. & also have some error checking formulas like any special charecters are entered or someing...


whtz happening now when i start writing on the text box, the formula is start checking in each every keystrok will pass.

I wish, once i complete writing and setfocus to another text box then only the formula should check not in each keystrok. is there any code or something Application.EnableEvents=false like... please help...

regards,