I have input the current date into column from macro using Date function. This column is formatted as dd/mm/yy.
I have then tried to input the values from this column into a textbox (txtEnteredOn) on a userform using to force the correct format:
Private Sub txtEnteredOn_Change()
txtEnteredOn = Format(txtEnteredOn.Value, "dd/mm/yy")
End Sub
However, the date shows as mm/dd/yy format.
How can I get it to show as dd/mm/yy format?
Paul
Bookmarks