Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help
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 |