Fred Wayne
Member
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.
Thank you so much in advance for all the usually given help.
Fred
I am sending the small file and some pictures of the mistake and the code I am using in the userform.
Code:
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