I have a userform that displays the Test time(or current time) .caption in a label. Then I have a textbox asking the user for the time product was pulled. Before the product can be tested it has to sit out for at least an hour after its been pulled. Is there a way within vba to subtract the difference between the test time and the time it was pulled and if the time difference is less then one hour dispaly a message box stating you have "xx" minutes left before product can be tested. Thanks to all for your help.

'Sets Test Time
Label4.Caption = Format(Time, "hh:mm")

Hi

You can use the combination of Sleep function and DateDiff to dynamically display the 'Time elapsed' or 'Time Left ..' on your user form.

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

can you give please give a tested example? Especially comparing to see if the elapsed time is greater or less than 1 hour. Thanks

Hi

Here is a sample

dStart = "25-08-2012 18:37:03" ' Change This to the App start time Variabled
if DAteDiff("h", dStart, Now()) > 1 then
' Elasped Time > 1
End if

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)