Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Anyone help.
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Anyone help.
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Anyone help.
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Anyone help.
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|