|
message box
Hi all,
At present i have to cells with dates input by staff, in the third cell the number of days are calculated. can i run a formula to bring up a message box to say issue prompt payment letter if the days calculated are over 15. thanks |
Yes, you could use a worksheet_change event triggered by input into the 2nd
cell. -- Don Guillett SalesAid Software "Monty" wrote in message ... Hi all, At present i have to cells with dates input by staff, in the third cell the number of days are calculated. can i run a formula to bring up a message box to say issue prompt payment letter if the days calculated are over 15. thanks |
How can you do this??
Thanks -----Original Message----- Yes, you could use a worksheet_change event triggered by input into the 2nd cell. -- Don Guillett SalesAid Software "Monty" wrote in message news:F21C86D4-75BD-4FE8-B774- ... Hi all, At present i have to cells with dates input by staff, in the third cell the number of days are calculated. can i run a formula to bring up a message box to say issue prompt payment letter if the days calculated are over 15. thanks . |
sorry tried this no luck!!
"Don Guillett" wrote: right click worksheet tabview codecopy/paste thismodify to suitSAVE Now, put a numbe in l5 and watch what happens. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address < "$L$5" Then Exit Sub Target.Offset(1, 4) = Target * 3 End Sub -- Don Guillett SalesAid Software "Mark" wrote in message ... How can you do this?? Thanks -----Original Message----- Yes, you could use a worksheet_change event triggered by input into the 2nd cell. -- Don Guillett SalesAid Software "Monty" wrote in message news:F21C86D4-75BD-4FE8-B774- ... Hi all, At present i have to cells with dates input by staff, in the third cell the number of days are calculated. can i run a formula to bring up a message box to say issue prompt payment letter if the days calculated are over 15. thanks . |
It does work!! What did you do?
-- Don Guillett SalesAid Software "Monty" wrote in message ... sorry tried this no luck!! "Don Guillett" wrote: right click worksheet tabview codecopy/paste thismodify to suitSAVE Now, put a numbe in l5 and watch what happens. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address < "$L$5" Then Exit Sub Target.Offset(1, 4) = Target * 3 End Sub -- Don Guillett SalesAid Software "Mark" wrote in message ... How can you do this?? Thanks -----Original Message----- Yes, you could use a worksheet_change event triggered by input into the 2nd cell. -- Don Guillett SalesAid Software "Monty" wrote in message news:F21C86D4-75BD-4FE8-B774- ... Hi all, At present i have to cells with dates input by staff, in the third cell the number of days are calculated. can i run a formula to bring up a message box to say issue prompt payment letter if the days calculated are over 15. thanks . |
Hi
I followed your instructions below and copied then pasted. In Cell A1 i input 12/10/04 In Cell B1 i input 12/12/04 In Cell C1 i input the formula =DAYS360(A1,B1) which returned the number 60. nothing else happened. CAn you please help. MArk -Original Message----- It does work!! What did you do? -- Don Guillett SalesAid Software "Monty" wrote in message news:32A701B1-4193-4210-B623- ... sorry tried this no luck!! "Don Guillett" wrote: right click worksheet tabview codecopy/paste thismodify to suitSAVE Now, put a numbe in l5 and watch what happens. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address < "$L$5" Then Exit Sub Target.Offset(1, 4) = Target * 3 End Sub -- Don Guillett SalesAid Software "Mark" wrote in message ... How can you do this?? Thanks -----Original Message----- Yes, you could use a worksheet_change event triggered by input into the 2nd cell. -- Don Guillett SalesAid Software "Monty" wrote in message news:F21C86D4-75BD-4FE8-B774- ... Hi all, At present i have to cells with dates input by staff, in the third cell the number of days are calculated. can i run a formula to bring up a message box to say issue prompt payment letter if the days calculated are over 15. thanks . . |
Did you notice the first line and my statement about cell L5?
If Target.Address < "$L$5" Then Exit Sub Now, put a numbe in l5 and watch what happens. change to B1 if that is the ONLY cell you want to influence this calculation. -- Don Guillett SalesAid Software "Mark" wrote in message ... Hi I followed your instructions below and copied then pasted. In Cell A1 i input 12/10/04 In Cell B1 i input 12/12/04 In Cell C1 i input the formula =DAYS360(A1,B1) which returned the number 60. nothing else happened. CAn you please help. MArk -Original Message----- It does work!! What did you do? -- Don Guillett SalesAid Software "Monty" wrote in message news:32A701B1-4193-4210-B623- ... sorry tried this no luck!! "Don Guillett" wrote: right click worksheet tabview codecopy/paste thismodify to suitSAVE Now, put a numbe in l5 and watch what happens. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address < "$L$5" Then Exit Sub Target.Offset(1, 4) = Target * 3 End Sub -- Don Guillett SalesAid Software "Mark" wrote in message ... How can you do this?? Thanks -----Original Message----- Yes, you could use a worksheet_change event triggered by input into the 2nd cell. -- Don Guillett SalesAid Software "Monty" wrote in message news:F21C86D4-75BD-4FE8-B774- ... Hi all, At present i have to cells with dates input by staff, in the third cell the number of days are calculated. can i run a formula to bring up a message box to say issue prompt payment letter if the days calculated are over 15. thanks . . |
Still no joy with this nothing happens.
when i hit run in the microsoft visual basic it comes up with a macros screen which is blank, so i have to cancel . any ideas will be welcome "Don Guillett" wrote: Did you notice the first line and my statement about cell L5? If Target.Address < "$L$5" Then Exit Sub Now, put a numbe in l5 and watch what happens. change to B1 if that is the ONLY cell you want to influence this calculation. -- Don Guillett SalesAid Software "Mark" wrote in message ... Hi I followed your instructions below and copied then pasted. In Cell A1 i input 12/10/04 In Cell B1 i input 12/12/04 In Cell C1 i input the formula =DAYS360(A1,B1) which returned the number 60. nothing else happened. CAn you please help. MArk -Original Message----- It does work!! What did you do? -- Don Guillett SalesAid Software "Monty" wrote in message news:32A701B1-4193-4210-B623- ... sorry tried this no luck!! "Don Guillett" wrote: right click worksheet tabview codecopy/paste thismodify to suitSAVE Now, put a numbe in l5 and watch what happens. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address < "$L$5" Then Exit Sub Target.Offset(1, 4) = Target * 3 End Sub -- Don Guillett SalesAid Software "Mark" wrote in message ... How can you do this?? Thanks -----Original Message----- Yes, you could use a worksheet_change event triggered by input into the 2nd cell. -- Don Guillett SalesAid Software "Monty" wrote in message news:F21C86D4-75BD-4FE8-B774- ... Hi all, At present i have to cells with dates input by staff, in the third cell the number of days are calculated. can i run a formula to bring up a message box to say issue prompt payment letter if the days calculated are over 15. thanks . . |
What I gave you originally was an example of how a worksheet_change event
works. You do NOT put in the ThisWorkbook or a regular module. It goes in the SHEET module as per my instruction of "right click sheet tabview codecopy/paste" The macro will fire AUTOMATICALLY when you enter something in the referenced cell. It is usually restricted to a column and below a row. In the example I sent, I restricted to cell L5, AS AN EXAMPLE. Exactly what did you modify the macro to? Copy/paste here. -- Don Guillett SalesAid Software "Monty" wrote in message ... Still no joy with this nothing happens. when i hit run in the microsoft visual basic it comes up with a macros screen which is blank, so i have to cancel . any ideas will be welcome "Don Guillett" wrote: Did you notice the first line and my statement about cell L5? If Target.Address < "$L$5" Then Exit Sub Now, put a numbe in l5 and watch what happens. change to B1 if that is the ONLY cell you want to influence this calculation. -- Don Guillett SalesAid Software "Mark" wrote in message ... Hi I followed your instructions below and copied then pasted. In Cell A1 i input 12/10/04 In Cell B1 i input 12/12/04 In Cell C1 i input the formula =DAYS360(A1,B1) which returned the number 60. nothing else happened. CAn you please help. MArk -Original Message----- It does work!! What did you do? -- Don Guillett SalesAid Software "Monty" wrote in message news:32A701B1-4193-4210-B623- ... sorry tried this no luck!! "Don Guillett" wrote: right click worksheet tabview codecopy/paste thismodify to suitSAVE Now, put a numbe in l5 and watch what happens. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address < "$L$5" Then Exit Sub Target.Offset(1, 4) = Target * 3 End Sub -- Don Guillett SalesAid Software "Mark" wrote in message ... How can you do this?? Thanks -----Original Message----- Yes, you could use a worksheet_change event triggered by input into the 2nd cell. -- Don Guillett SalesAid Software "Monty" wrote in message news:F21C86D4-75BD-4FE8-B774- ... Hi all, At present i have to cells with dates input by staff, in the third cell the number of days are calculated. can i run a formula to bring up a message box to say issue prompt payment letter if the days calculated are over 15. thanks . . |
try this formula in col D
=IF(DAYS360(B5,C5)=15,"Do Letter",DAYS360(B5,C5)) or =IF(DAYS360(B5,C5)=15,"Do Letter","OK") -- Don Guillett SalesAid Software "Don Guillett" wrote in message ... What I gave you originally was an example of how a worksheet_change event works. You do NOT put in the ThisWorkbook or a regular module. It goes in the SHEET module as per my instruction of "right click sheet tabview codecopy/paste" The macro will fire AUTOMATICALLY when you enter something in the referenced cell. It is usually restricted to a column and below a row. In the example I sent, I restricted to cell L5, AS AN EXAMPLE. Exactly what did you modify the macro to? Copy/paste here. -- Don Guillett SalesAid Software "Monty" wrote in message ... Still no joy with this nothing happens. when i hit run in the microsoft visual basic it comes up with a macros screen which is blank, so i have to cancel . any ideas will be welcome "Don Guillett" wrote: Did you notice the first line and my statement about cell L5? If Target.Address < "$L$5" Then Exit Sub Now, put a numbe in l5 and watch what happens. change to B1 if that is the ONLY cell you want to influence this calculation. -- Don Guillett SalesAid Software "Mark" wrote in message ... Hi I followed your instructions below and copied then pasted. In Cell A1 i input 12/10/04 In Cell B1 i input 12/12/04 In Cell C1 i input the formula =DAYS360(A1,B1) which returned the number 60. nothing else happened. CAn you please help. MArk -Original Message----- It does work!! What did you do? -- Don Guillett SalesAid Software "Monty" wrote in message news:32A701B1-4193-4210-B623- ... sorry tried this no luck!! "Don Guillett" wrote: right click worksheet tabview codecopy/paste thismodify to suitSAVE Now, put a numbe in l5 and watch what happens. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address < "$L$5" Then Exit Sub Target.Offset(1, 4) = Target * 3 End Sub -- Don Guillett SalesAid Software "Mark" wrote in message ... How can you do this?? Thanks -----Original Message----- Yes, you could use a worksheet_change event triggered by input into the 2nd cell. -- Don Guillett SalesAid Software "Monty" wrote in message news:F21C86D4-75BD-4FE8-B774- ... Hi all, At present i have to cells with dates input by staff, in the third cell the number of days are calculated. can i run a formula to bring up a message box to say issue prompt payment letter if the days calculated are over 15. thanks . . |
| All times are GMT +1. The time now is 05:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com