The value ranges are in B2 to B3 on a sheet called Do Not Delete how would i
edit the macro code.

"R.VENKATARAMAN" wrote:

date 1 and date 2 are in A1 and A2

use something like this sub

Public Sub test()
If Range("a2") < Range("a1") Then
MsgBox "the two dates are not same"
End If
End Sub

"John" wrote in message
...
Can anyone help me. i need a macro code for a project im working on.

the code i need is.

if date1 is not the same as date2 the it brings up a dialog message box to
inform you.