View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default How to set TIME condition for if-statement?

If Time #12:30:00 PM# And Time < #2:30:00 PM# Then
'rest of code

End If

"Eric" wrote in message
...
I would like to process following code if time is between 12:30PM and
2:30PM.
Does anyone have any suggestions on how to code this if-statement in VBA
coding for Excel's macro?
Thanks in advance for any suggestions
Eric

if time is between 12:30PM and 2:30PM then
(
Coding
);