How to make user input .Value entered as specified British date format and not auto-ing to American

[Tardisgx]

For example I enter 01/05/19 The 1st of April 2019 in my userbox

Exit the macro 05/01/19 is entered in the cell instead.

            Sheets("View").Range("B3").Value = Me.Specifictext.Value

I can only assume this is a Microsoft feature that reverts the value to American.

 

[BlueHornet]

See what's available to you at Control Panel / Region. That's the place to start, anyway.

 

[Fluff]

Try

Sheets("View").Range("B3").Value = CDate(Me.Specifictext.Value)

 

[Tardisgx]

Cool that worked. Why did it work? What is CDate?

 

[Fluff]

CDate is a conversion function that converts the value into a date.