Trouble with a boolean statement using textbox value

[RunTime91]

Greetings ~

I am trying to create a Boolean condition with the value of a textbox which has its value expressed in "hh:mm:ss" format.

Below is the conditional statement which simply will not read correctly

If Format(.TextBox74.Text, "hh:mm:ss") > "3:00" Then
        .TextBox74.BackColor = vbGreen
      Else: .TextBox74.BackColor = vbRed
End If

The current value of TextBox 74 is 21:16 and yet it blows right past the 'then' and onto the 'Else'

Help??

Thank You ~

 

[MrTeeny]

Try expressing your time as TimeValue("03:00:00")

 

[Roxxien]

I'm truly not sure but is it possible that after setting your textbox 74 to hh:mm:ss, VBA thinks you have 00:21:16 which is smaller then 3:00:00?

If this is the possibility, you can try to solve by changing hh:mm:ss by hh:mm

 

[Rick Rothstein]

Instead of this...

If Format(.TextBox74.Text, "hh:mm:ss") > "3:00" Then

try this...

If CDate(.TextBox74.Text) > #3:00# Then

 

[RunTime91]

That's why you're an MVP Rick ~

Works great!

Thank you very much