Ctrl OR STOP Dates

[Maurizio]

Hi all,

i have this important (european date) dd/mm/yyyy
Date_VIP = 17/09/2011

a1 --> Date INI
a2 --> Date END

how can I stop a Sub when

i.e.:

OK
a1 01/01/11
a2 16/09/11

STOP
a1 01/09/11
a2 17/09/11

OK
a1 17/09/11
a2 31/12/11

TIA. maurizio.

 

[doofusboy]

Something like this:

If Range("A2").Value = "17/09/11" Then
Exit Sub
End If

 

[Maurizio]

I need ctrl two box/period:
a1 AND a2

 

[doofusboy]

In that case you should add an 'AND' clause to your If statement.