ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Date limited (https://www.excelbanter.com/excel-programming/334096-date-limited.html)

Michael

Date limited
 
How to date limit a code. I need something like this:

If (Date today)Date 22.08.05 then Msgbox €œ€

Else

End if


Bob Phillips[_7_]

Date limited
 
If Date DateSerial(2005,08,22) Then
MsgBox "Too late"
End If

--
HTH

Bob Phillips

"Michael" wrote in message
...
How to date limit a code. I need something like this:

If (Date today)Date 22.08.05 then Msgbox ""

Else

End if




Michael

Date limited
 
Thank's Bob :-)

"Bob Phillips" wrote:

If Date DateSerial(2005,08,22) Then
MsgBox "Too late"
End If

--
HTH

Bob Phillips

"Michael" wrote in message
...
How to date limit a code. I need something like this:

If (Date today)Date 22.08.05 then Msgbox ""

Else

End if






All times are GMT +1. The time now is 11:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com