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


.