Re: $$Excel-Macros$$ Uday File

2015-06-22 Thread uday
Dear Ashish Kumar ji, i wANT TO EXTRACT DATA OF HIGHLIGHTED CELLS IN ONE SHEET COLUMNWISE THERE ARE DATA OF AROUND 400 PEOPLE I WANT EXTRACT ONLY HIGHLIGHTED CELLS AND THERE RESPECTIVE RECORDS.. On Tuesday, 16 June 2015 16:54:01 UTC+5:30, Ashish Kumar wrote: > > Elaborate more > -- Are you =E

Re: $$Excel-Macros$$ reached at certain value Message shows

2015-06-22 Thread Kumar Bhanushali
Dear Sir, Sorry sir, There is an error , The message which I want to display is the actual difference between the 2 values. And this MSG will display when the difference is 5000 or less than of 5000. Regards, Kumar Bhanushali Re: $$Excel-Macros$$ reached at certain value Message shows

Re: $$Excel-Macros$$ reached at certain value Message shows

2015-06-22 Thread Kumar Bhanushali
Dear Abhishek Bhai, Done. Thanks A Lot. Regards, Kumar Bhanushali Re: $$Excel-Macros$$ reached at certain value Message shows Abhishek Jain to: MS EXCEL AND VBA MACROS 22-06-15 03:24 PM Sent by: excel-macros@googlegroups.com From: Abhishek Jain To: MS EXCEL AND VBA MACROS

Re: $$Excel-Macros$$ reached at certain value Message shows

2015-06-22 Thread Abhishek Jain
Not clear what exactly do you want but if you put this code in the Sheet 1 module then it will give a message whenever the value is A1 is 1000. *Private Sub Worksheet_Change(ByVal Target As Range)* *If Sheets("Sheet1").Range("A1") = 1000 Then* *MsgBox "A1 value is now 1000"* *Else* *End If* *End S