$$Excel-Macros$$ Re: Event for cell data entry

the macro, add: > > Application.EnableEvents = False > > then, before the End Sub, add: > > Application.EnableEvents = True > > It will then only run once. > > Paul > > ------ > *From:* mridu paban boruah > *To:* excel-macros@googlegroups.com > *Sen

$$Excel-Macros$$ Event for cell data entry

Hi All, I want a few cells to be in a definite number format.So while a user enters data in those cells the code should check and throw up a msg if format is not matching. I hav used the below code with an event. But the problem is when the code Range("B25").Value = "" is encountered the loop st