Re: $$Excel-Macros$$ Message POP up

2015-06-23 Thread Mandeep Baluja
Welcome :D On Tuesday, June 23, 2015 at 6:03:56 PM UTC+5:30, Kumar Bhanushali wrote: > > > *Dear Sir,* > > It works ,,, Thanks A Lot!! > > > > > *Regards, Kumar Bhanushali* > > > *Re: $$Excel-Macros$$ Message POP up* > *Mandeep Baluj

Re: $$Excel-Macros$$ Message POP up

2015-06-23 Thread Kumar Bhanushali
Dear Sir, It works ,,, Thanks A Lot!! Regards, Kumar Bhanushali Re: $$Excel-Macros$$ Message POP up Mandeep Baluja to: excel-macros 23-06-15 05:49 PM Sent by: excel-macros@googlegroups.com Cc: kumar.bhanushali From: Mandeep Baluja To: excel-macros@googlegroups.com Cc

Re: $$Excel-Macros$$ Message POP up

2015-06-23 Thread Mandeep Baluja
Put this code into your summary sheet and tell me how is it working ? Private Sub Worksheet_Change(ByVal Target As Range) R = Target.Row c = Target.Column If Not Intersect(Target, Range("d8:g15")) Is Nothing Then If Target.Value > Cells(R + 17, c) Then MsgBox "You have exceed the limit" & "-" &

Re: $$Excel-Macros$$ Message POP up

2015-06-23 Thread Kumar Bhanushali
ds, Kumar Bhanushali Re: $$Excel-Macros$$ Message POP up Mandeep Baluja to: excel-macros 23-06-15 04:14 PM Sent by: excel-macros@googlegroups.com Cc: kumar.bhanushali From: Mandeep Baluja To: excel-macros@googlegroups.com Cc: kumar.bhanush...@pmcprojects.com S

Re: $$Excel-Macros$$ Message POP up

2015-06-23 Thread Mandeep Baluja
UTC+5:30, Kumar Bhanushali wrote: > > > *Dear Sir,* > > It's working, but I same code for multiple cells. > > like from D8:D15, E8:E15, F8:F15 & G8:G15. > > > > > > > *Regards, Kumar Bhanushali * > > >*Re: $$Excel-Macros$$ Messag

Re: $$Excel-Macros$$ Message POP up

2015-06-23 Thread Kumar Bhanushali
Dear Sir, It's working, but I same code for multiple cells. like from D8:D15, E8:E15, F8:F15 & G8:G15. Regards, Kumar Bhanushali Re: $$Excel-Macros$$ Message POP up Mandeep Baluja to: excel-macros 23-06-15 03:58 PM Sent by: excel-macros@googlegroups.com Cc: kumar.b

Re: $$Excel-Macros$$ Message POP up

2015-06-23 Thread Mandeep Baluja
msg. > > > > > > > *Regards, Kumar Bhanushali * > > >*Re: $$Excel-Macros$$ Message POP up* > *Mandeep Baluja * to: excel-macros > 23-06-15 03:41 PM > >Sent by: *excel-...@googlegroups.com * Cc: > kumar.bhanushali > >

Re: $$Excel-Macros$$ Message POP up

2015-06-23 Thread Mandeep Baluja
2:54:51 PM UTC+5:30, Kumar Bhanushali wrote: >> >> >> *Dear Sir,* >> >> there is a problem, that it restricts the qty. >> >> I don't want to restrict the qty, i just want to show the message with >> qty balance. >> >> >

Re: $$Excel-Macros$$ Message POP up

2015-06-23 Thread Mandeep Baluja
7;t want to restrict the qty, i just want to show the message with qty > balance. > > > > > > > *Regards, Kumar Bhanushali* > > >*Re: $$Excel-Macros$$ Message POP up* > *Mustapha LMIDMANI * to: excel-macros > 23-06-15 01:35 PM > >Sent

Re: $$Excel-Macros$$ Message POP up

2015-06-23 Thread Kumar Bhanushali
Dear Sir, there is a problem, that it restricts the qty. I don't want to restrict the qty, i just want to show the message with qty balance. Regards, Kumar Bhanushali Re: $$Excel-Macros$$ Message POP up Mustapha LMIDMANI to: excel-macros 23-06-15 01:35 PM Sent by: excel-m