Thread
:
message box
View Single Post
#
7
Mark
Posts: n/a
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
.
.
Reply With Quote