I've used something similar in VBA. Here is what I used:
Dim newHour, newMinute, newSecond, waitTime
newHour = Hour(Now())
newMinute = Minute(Now())
newSecond = Second(Now()) + 5 ' the number specifies the amount of time to wait
waitTime = TimeSerial(newHour, newMinute, newSecond)
' PERFORM SOME FUNCTION
Application.Wait waitTime ' pause code
The problem is I haven't been able to successfully convert this to
VB.
Jeff Armstrong
Sr. Systems Mgr
SBC Services, Inc.