Check time

[gibbo1715]

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]

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