Sleeper: Time in VBA - Display's in Serial Number

[thombill]

I have a UserForm that I want the user to be able to enter the time in military standards. The time is then transferred to the report spreadsheet.

The time is displayed correctly when entering and it is displayed correctly on the final report, however the problem:

Once the user enters the time using 24:59 format and proceeds to
the next textbox, the time format changes to the serial time on the
UserForm. The result works on the report page, but it looks incorrect to
the user and it is hard for them to go back and edit the time, if needed.

So, what I am looking for is a way to format the TextBox on the userform to display what is actually typed in and not convert the time to a serial number.

Thank you in advance!

:banghead:

[Norie]

How is the time being transferred to/from the textbox/spreadsheet?

Are you using the LinkedCell property?

[thombill]

Currently, I have used the control source to link the textbox to the report spreadsheet.

[Norie]

:oops:

I meant the ControlSource property.