As you may see I have ' marked above steeps as description so that macro would ignore this one steep and macro continues to run as it should do.Code:'Else 'If Range("w17").Value < Date Then 'answer = MsgBox("The delivery date is set in the past." & vbNewLine & "Click OK if date is correct." & vbNewLine & "Click Cancel to change.", vbQuestion + vbOKCancel, "Delivery date!") 'If answer = vbCancel Then 'Exit Sub*****************------------------ 'Range("w17").Select
The problem is in the lines above.
If date is in the past macro returns alert and cancels it if I cancel or continues to next steep.
But if the date is not in the past then macro stops at this steep.
I can't figure it out what is wrong.
Any help truly appreciated.
Regards,
Albert




Reply With Quote
Bookmarks