A
Andy
Hi
Can anyone help with the following:-
I input this:-
Option Explicit
Public Function PromptPayment()
MsgBox "Please issue Prompt Payment Letter and input
relevant information to PP spreadsheet"
End Function
And then this in the appropraite cell
=IF((F4-E4)>=15,PromptPayment()+F4-E4,F4-E4)
It works great when the information is input I.e Two
dates are input which are greater than 15 days a message
box appears.
The problem is that when I go to reopen this workbook the
message box appears before it opens and you have to click
ok. I can get rid of this by deleting the cell with the
more than 15 days however I need this information to be
keep can anyone please help.
Thanks
Can anyone help with the following:-
I input this:-
Option Explicit
Public Function PromptPayment()
MsgBox "Please issue Prompt Payment Letter and input
relevant information to PP spreadsheet"
End Function
And then this in the appropraite cell
=IF((F4-E4)>=15,PromptPayment()+F4-E4,F4-E4)
It works great when the information is input I.e Two
dates are input which are greater than 15 days a message
box appears.
The problem is that when I go to reopen this workbook the
message box appears before it opens and you have to click
ok. I can get rid of this by deleting the cell with the
more than 15 days however I need this information to be
keep can anyone please help.
Thanks