Vba: Time Delay to execute - Input from Cell Value

**vidyuthrajesh** · 03-18-2014, 08:55 AM

Hello,

i would like to delay or pause the application for duration mentioned by the user in the cell Value. The following code gives error message. How do i get this done? Thanks for the assistance. Note : If i store "0:00:10" in Tvalue directly it is running as expected but i would like that to be picked from Cell reference.

Sub test()
tvalue = Range("B1").Value
Application.Wait (Now + TimeValue(tvalue))
Range("A1").Value = 10
'Application.Wait (Now + TimeValue("0:00:01"))
End Sub

**Kaper** · 03-18-2014, 10:24 AM

tvalue = Range("B1").text

Because after VBA help:

TimeValue Function

Returns a Variant (Date) containing the time.

Syntax

TimeValue(time)

The required time argument is normally a string expression representing a time from 0:00:00 (12:00:00 A.M.) to 23:59:59 (11:59:59 P.M.), inclusive.

and with
00:00:01
in B1
[B1].value would be 1.15740740740741E-05
while [B1].text is "00:00:01" as needed for timevalue