Re: $$Excel-Macros$$ Change Event

2013-05-07 Thread Abhishek Jain
You're welcome. On Tue, May 7, 2013 at 3:07 PM, Chandra Shekar wrote: > Hi, > > Thanks for your reply and it worked. > > Regards, > > Chandru > > On Tue, May 7, 2013 at 1:54 PM, Abhishek Jain wrote: > >> Private Sub Worksheet_Change(ByVal Target As Range) >> If Not Intersect(Target, Target.Work

Re: $$Excel-Macros$$ Change Event

2013-05-07 Thread Chandra Shekar
Hi, Thanks for your reply and it worked. Regards, Chandru On Tue, May 7, 2013 at 1:54 PM, Abhishek Jain wrote: > Private Sub Worksheet_Change(ByVal Target As Range) > If Not Intersect(Target, Target.Worksheet.Range("A1:A1000")) Is Nothing > Then > MsgBox "A cell from A1 to A1000 is changed." >

Re: $$Excel-Macros$$ Change Event

2013-05-07 Thread Abhishek Jain
Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Target.Worksheet.Range("A1:A1000")) Is Nothing Then MsgBox "A cell from A1 to A1000 is changed." End If End Sub On Tue, May 7, 2013 at 1:11 PM, Chandra Shekar wrote: > Hi, > > How to check cell ranges using change even

$$Excel-Macros$$ Change Event

2013-05-07 Thread Chandra Shekar
Hi, How to check cell ranges using change event. for ex: I need to check whether user is entering data only in range A1:A1000. Thanks in advance. Regards, Chandra Shekar B -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Faceboo