I have a small user interface, using Excel's Form functionality, which allows users to input start and finish dates for projects.

If the user puts in dates that are available in both the US and UK formats (e.g. 7th May 2018, 5/7/2018) the variable will come out in the US format (e.g. 5th July 2018, 5/7/2018). However, if the dates are not available in both formats (e.g. 31st August 2018, 31/8/2018), the variable will return in the (correct) UK format.

My current code for the particular variables in the form is as follows:

```
Private Sub Calculate_Click()

    sDate = CDate(sDate.Text)
    eDate = CDate(eDate.Text)

    If sDate = vbNullString Then
        sDate = Now()
    End If

    If eDate = vbNullString Then
        eDate = Now() + 40
    End If

    If HoursPD = vbNullString Then
        HoursPD = 6
    ElseIf HoursPD > 7.5 Then
        HoursPD = 7.5
    End If

    Me.Hide

End Sub

```

Is there any way to ensure that the variable format is fixed to the UK version?