I am trying to write a small piece of VBA to give a a yes / no answer.
So if the user has selected the correct month save the data. If the user has no selected the correct month either do nothing or refresh sheet.
This is the code that i have written.
MsgBox "ARE YOU SAVING TO THE CORRECT MONTH", vbYesNo
If answer = vbYes Then
If answer = vbNo Then