Code to Check Time

N

Novice1

Registered User.

Local time

Today, 00:27

Joined

Mar 9, 2004

Messages

385

• Sep 23, 2010

• #1

I need help writing the correct VBA code ... I want to create an If/Then statement that checks the time. If the time is between 09:00 and 3:00 pm then (pop up msgbox)...

I'm not writing the time code correctly ... any help will be appreciated.

If Now() = Between >= [09:00:00] And <= [15:00:00] Then

 

boblarson

Smeghead

Local time

Today, 00:27

Joined

Jan 12, 2001

Messages

32,059

• Sep 23, 2010

• #2

It would be:

Code:

If Time Between #09:00:00# And #15:00:00# Then

You use the TIME function instead of NOW and you don't use Time = Between - just Time Between.

 

L

leddy

New member

Local time

Today, 08:27

Joined

Jul 3, 2008

Messages

9

• Sep 23, 2010

• #3

If Hour(Now()) >= 9 And Hour(Now()) <= 15 Then

HTH

leddy

see Bob's post above

 

Last edited: Sep 23, 2010

N

Novice1

Registered User.

Local time

Today, 00:27

Joined

Mar 9, 2004

Messages

385

• Sep 23, 2010

• #4

Thank you very much