thombill
08-25-2005, 08:18 AM
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:
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: