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,
Bookmarks