How to validate Time in a Data Entry Form?

[uknwtheusername]

Hi everyone,

I'm making a data entry form for a user, and one of the fields is in a time format (mm:ss). Is there any way that I can validate that field in "cmdOK_Click()" so that when the user clicks "ok" on the data entry form, if they haven't entered a date a msgbox comes up.

I tried IsNumeric with an If function but to no prevail.

Thank you for your help!

 

[mathchick]

you could try this:

if Range("A1").text like ##:##

~Mathchick

 

[uknwtheusername]

you could try this:

if Range("A1").text like ##:##

~Mathchick

Thanks for your reply!

I'm getting an error message when I try to plug that in, here's the code so you can check it out and see what's up:

If Range(txtDuration).text like ##:## End If

I'm getting a message saying: "Compile error. Expected: expression" and it highlights the '#' tags.

I assumed that 'Range("A1")' from your example was equal to the field I want to validate (btw, if you need to know, the duration is entered into the H:H column of my worksheet, but not necessarily at H:1)

Thanks for your help, and please help me out :D

 

[mathchick]

whoops:

if Range("A1").text like "##:##"

that work?
~Mathchick

 

[uknwtheusername]

whoops:

if Range("A1").text like "##:##"

that work?
~Mathchick

I messed around with what you gave me and I ended up with this:

If txtDuration.Value = Text Then
txtDuration.Value = "##:##"
End If

It seems to be working fine, so thanks for your help man, cheers!