Timing trigger

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone suggest suitable code to insert into an existing piece of code,
which will allow it to run only between certain hours each day.
Thanks
 
Dave said:
Can anyone suggest suitable code to insert into an existing piece of code,
which will allow it to run only between certain hours each day.
Click to expand...


How about putting the code in an If block:

If TimeValue(Now) > #7:00# And TimeValue(Now) < #17:00# Then
' your code here
Else
MsgBox "not now"
End If
 
That worked
Thanks
--
Dave Hawks


Marshall Barton said:
How about putting the code in an If block:

If TimeValue(Now) > #7:00# And TimeValue(Now) < #17:00# Then
' your code here
Else
MsgBox "not now"
End If
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using VBA to trigger a certain slide 0
Msg Box 1
Programmatically trigger an event 2
Excel Excel IF variable based on time of day 0
How do variables work? 5
Trigger action after 'x' number of clicks. Possible vba? 0
Making fields trigger a vb-code 0
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top