assuming the dates are shown in c9 and f9 at its most basic
Sub Macro1()
'
' Macro1 Macro
'

'
If Range("C9") < Range("F9") Then
MsgBox "Dates are not the same"
End If


End Sub
--
paul
remove nospam for email addy!



"John" wrote:

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.