Hi Guys,
I am having issues with the date appearing the way I need it to in my userform textbox. At the moment any entry that I make as "dd/mm/yyyy" is converted to the spreadsheet as "mm/dd/yyyy"
i.e 09/06/2020 changes to 06/09/2020
The code I am using is this directly below
I have tried a few variations of adding DateTextBox.Value = Format(DateTextBox.Value, "dd/mm/yyyy") without success.
Can you help?
P.S. a bonus help would be something to prevent date entry being entered in any other way to ensure consistency in the data
I am having issues with the date appearing the way I need it to in my userform textbox. At the moment any entry that I make as "dd/mm/yyyy" is converted to the spreadsheet as "mm/dd/yyyy"
i.e 09/06/2020 changes to 06/09/2020
The code I am using is this directly below
VBA Code:
Cells(EmptyRow, 4).value = DateTextBox.Value
I have tried a few variations of adding DateTextBox.Value = Format(DateTextBox.Value, "dd/mm/yyyy") without success.
Can you help?
P.S. a bonus help would be something to prevent date entry being entered in any other way to ensure consistency in the data