I need a message box to appear to let the user know that if the date that the user is entering is more than 12 months from the last date entered.
There will be two cells used for date on the worksheet. One cell will be a previous date and the other cell will be the date being entered.
I need a Macro that will look at the previous date and compare it to the date being entered. If the date being entered is in excess of 12 months a pop up window will let the user know.
Thanks, Sam
There will be two cells used for date on the worksheet. One cell will be a previous date and the other cell will be the date being entered.
I need a Macro that will look at the previous date and compare it to the date being entered. If the date being entered is in excess of 12 months a pop up window will let the user know.
Thanks, Sam