explanation of time in VB

[poorwallace]

Boy...I sure seem to be asking more questions that I try to answer these days...So here is my question...

I have the following code, and it works....

Dim CurrentTime
CurrentTime = Now()

If CurrentTime < "3:45:00 PM" Then
    MsgBox "It's not time yet!"
End If

But I would like to know how I can reference CurrentTime against say "15:45:00" instead of "3:45:00 PM" (as I have figured out, the PM part of that is critical for the way I have approached this situation).

Thanks
Wally

 

[XLGibbs]

CurrentTime = Format(now()),"h:mm")

If CurrentTime < "15:45" then
Msgbox "not yet"
End If

 

[poorwallace]

Thanks...I understand your approach, so I'll play around with it to customize to what I'm looking for.

Thanks Again! I'm always learning!