-
Problem with format "12/31/1899"
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules