One way:

=IF((C1-B1)=15,PromptPayment()+C1-B1,C1-B1)

In article ,
"Monty" wrote:

When you hit the ok button in the message box the cell reverts back to zero,
can this be changed so the correct amount of days are shown even if they are
over 15.