UserForms - Time Format oddity

[KG Old Wolf]

I am using a textbox to capture user input for clock time "start and stop". All is fine EXCEPT for when a person enters 12:00... then I get a displayed format of 12:05 AM

Enter 11:59 and you get 11:59 AM; 12:01 and you get 12:01 PM.... but it goes crazy when I enter 12:00

Oh, btw - the data is stored and presented correctly once the userform is completed... I can then go merrily on my way to do whatever computation I want... it just shows up wrong on the userform and only if 12:00 is entered, every other time displays correctly....

neither of these work:
Start_Time = Format(Start_Time.Value, "hh:mm AM/PM")
Stop_Time = Format(Stop_Time.Value, "h:mm AM/PM;@")

Any and all suggestions most appreciated....

Ken

 

[GTO]

Sorry no help, with '12:00' typed in, I got '12:00 PM' on both.

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Me.TextBox1 = Format(Me.TextBox1.Value, "hh:mm AM/PM")
End Sub
Private Sub TextBox2_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Me.TextBox2 = Format(Me.TextBox2.Value, "h:mm AM/PM;@")
End Sub