View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Corey ....[_2_] Corey ....[_2_] is offline
external usenet poster
 
Posts: 45
Default Calculating Hours from Textbox Times

Thank you BOB.

Perfect !!

"Bob Phillips" wrote in message
...
Private Sub TextBox9_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If TextBox8.Text < "" And TextBox9.Text < "" Then _
Label63.Caption = (TimeValue(TextBox9.Value) - _
TimeValue(TextBox8.Value)) * 24
End Sub



--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Corey ...." wrote in message
...
Private Sub TextBox9_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If TextBox8 < "" And TextBox9 < "" Then Label63 = (TextBox9.Value -
TextBox8.Value) * 24
End Sub

With the above line of code, i am trying to gain the value in Hours
between the 2 textboxes, but i get an error.

Textbox8.value = 3:30PM
Textbox8.value = 7:30AM

??