View Full Version : [SOLVED:] Check time
gibbo1715
08-25-2005, 06:02 AM
can anyone help with some simple code thats confusing me at the mo, i want a macro that checks if the time is between 14.00 and 15.00 and if it is to perform an action
Thanks
Gibbo
gibbo1715
08-25-2005, 06:20 AM
Cancel that, heres the answer, having a daft moment
Dim strDate As Date
strDate = Format(Now, "hh:mm")
If strDate > "14:00" And strDate < "15:00" Then
' do something
End If
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.