Textbox with Time format > 24 hours

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

any help please?