Help with Textbox Time Display

[Fred Wayne]

Hello. I need help with the following thing....I have made a small file to set an specific time or ETA for work stuff. My problem is that I can not make the TextBoxes to display the time format. Instead of displaying what I need(Time Format), it displays a series of long and extended numbers. Is there the possibility to have a code for the textboxes to display the time format. If if could be AM/PM time, it would be amazing.
I am sending the small file and some pictures of the mistake and the code I am using in the userform.

Private Sub CommandButton1_Click()
Worksheets("Locator").Range("B3").Value = TextBox2.Text
TextBox3.Text = Sheets("Locator").Range("B4").Value

End Sub

Private Sub UserForm_Initialize()
'Displays the time of correponding cells
TextBox1.Text = Sheets("Locator").Range("B2").Value
TextBox2.Text = Sheets("Locator").Range("B3").Value
TextBox3.Text = Sheets("Locator").Range("B4").Value
End Sub

Thank you so much in advance for all the usually given help.



Fred

 

[vletm]

Fred Wayne
Have You tried to use
TextBox1.Text = Format( Your_value,"hh:mm:ss")
or
TextBox1.Text = Text(Your_value,Your_wanted_format)
Use needed formats as You need to see.

 

[Belleke]

Like this?

 

[Marc L]

Is there the possibility to have a code for the textboxes to display the time format. If if could be AM/PM time, it would be amazing.

Hi, if the cells are well formatted so obviously use at least the cell Text property rather than the Value property ! …​

​

 

[Fred Wayne]

Yesssssssssssssssssssssssssssss That is what I needed. Thank you so much. Amazing. I do not have words to thank you again