Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 . |
#5
|
|||
|
|||
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 . |
#6
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Message | Excel Discussion (Misc queries) | |||
Error message with embedded objects. | Setting up and Configuration of Excel | |||
Error Message Appearing | Excel Discussion (Misc queries) | |||
Error Message appearing when saving a file | Excel Discussion (Misc queries) | |||
#num! error message | Excel Worksheet Functions |