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