Hi all
I have a textbox on my userform where a user enters time >24 hours
These total time durations can be as high as 75:25:11 (Hours:minutes:seconds) or as high as 752:45:51
Is there a way that i can validate the textbox so that so that time can only be entered as [h]:mm:ss? or add a validation check code to my command button which adds the data which will display an error message if the wrong format has been entered?
I know that VBA doesnt like the excel format [h]:mm:ss
Bookmarks