This is something I have not done before and need some help.
I have the following VBA which I recorded. It does the job perfectly.
What I would like to do is to make sure that the user confirms YES or NO that the date is correct.
Ideally the message box needs to show the date that has been entered for a YES/No confirmation
' datepaste Macro
nxtRow = Sheets("SCARD").Range("R" & Rows.Count).End(xlUp).Row + 1
Destination:=Sheets("SCARD").Range("R" & nxtRow)
("K6") is the date that is entered.
How do I write my requirement, and how do I apply it to the above VBA
Your help would be much appreciated