If statement with timevalue

[jaryszek]

hi,

i want to add vba to check if inputted time is 00:00:05 or whatever user will input.

Screenshot_23.png

Please Login or Register  to view this content.

but this is not catching this. How can i write the code?

I do not want to use very strange strings like :

Please Login or Register  to view this content.

Please help,
Best,
Jacek

[Keebellah]

Use

Please Login or Register  to view this content.

for 5 seconds,

[Keebellah]

Try this modified your code a little

[jaryszek]

ok thank you!
I found also solution.

working:

TimeValue(Format((activesheet.Cells(2, 4).Value), "hh:mm:ss"))

Best,
Jacek

[Keebellah]

Great, don't forget to mark the post SOLVED