hi,
i want to add vba to check if inputted time is 00:00:05 or whatever user will input.
Screenshot_23.png
but this is not catching this. How can i write the code?![]()
If ActiveSheet.[D2].Value = TimeValue("00:00:05") Then MsgBox "ok" End If
I do not want to use very strange strings like :
Please help,![]()
?ActiveSheet.[D2].Value 5,78703703703704E-05
Best,
Jacek
Bookmarks