Juan Cornetto
New Member
- Joined
- Mar 5, 2013
- Messages
- 44
I know there are millions of similar questions and solutions to changing the date form in a text box but all the ones I have found is for user inputs into the text box on the form. I have a user form which is populated from cells in a selected row with the following code
With Me
.DateTextBox.Value = Cells(ActiveCell.Row, "A").Value
.DateTextBox.Text = Format("dd/mm/yy")
.TimeTextBox.Value = Cells(ActiveCell.Row, "C").Value
.TextBox1.Value = Cells(ActiveCell.Row, "D").Value
.DescriptionTextBox.Value = Cells(ActiveCell.Row, "F").Value
.DoTextBox.Value = Cells(ActiveCell.Row, "G").Value
.ReportTextBox.Value = Cells(ActiveCell.Row, "H").Value
End With
It all works except the date in the text box appears in mm/dd/yy format instead of dd/mm/yy.
Any help would be appreciated
With Me
.DateTextBox.Value = Cells(ActiveCell.Row, "A").Value
.DateTextBox.Text = Format("dd/mm/yy")
.TimeTextBox.Value = Cells(ActiveCell.Row, "C").Value
.TextBox1.Value = Cells(ActiveCell.Row, "D").Value
.DescriptionTextBox.Value = Cells(ActiveCell.Row, "F").Value
.DoTextBox.Value = Cells(ActiveCell.Row, "G").Value
.ReportTextBox.Value = Cells(ActiveCell.Row, "H").Value
End With
It all works except the date in the text box appears in mm/dd/yy format instead of dd/mm/yy.
Any help would be appreciated