Hi,

I need help with formatting the time in ActiveX textboxes . For example, when I enter "22:00" in textbox7, all the other textboxes start out as "12/31/1899". The time calculated is correct, I just want to get rid of the "12/31/1899".

Looking all over online and can't find anything to fix it. Any help is appreciated!

Thanks!

Heres the code:

Private Sub ToggleButton20_Click()
If ToggleButton20.Value = True Then
ToggleButton20.BackColor = vbGreen

TextBox8.Value = TimeValue(TextBox7.Value) + TimeValue("3:25")
TextBox9.Value = TimeValue(TextBox7.Value) + TimeValue("6:50")
TextBox10.Value = TimeValue(TextBox7.Value) + TimeValue("10:15")
TextBox11.Value = TimeValue(TextBox7.Value) + TimeValue("13:40")
TextBox12.Value = TimeValue(TextBox7.Value) + TimeValue("17:05")
TextBox13.Value = TimeValue(TextBox7.Value) + TimeValue("22:30")

end if
End sub