VBA issue with date format

[Goodangel]

Hello,

I have an issue with a date format in an excel file.

When I run the report (excel is connected with Noetix and Oracle e business suite) I have results with no problem. Currently I am in Vienna, Austria.

However when a colleague of mine in Vietnam run the same report then his has en error. The VBA code that is running is the following. The date format in my laptop (windows 7) is dd/mm/yyyy and as I saw in my colleague (windows 8 or 10) is mm/dd/yyyy.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Target.Address = "$D$7" Then

    user_name = InputBox("Please enter your Oracle user name:")
    If user_name = "" Then End
    Oracle_password = InputBox("Please enter your Oracle password:")
    If Oracle_password = "" Then End
    end_date = Format(InputBox("Please enter the period end date in the format dd/mm/yyyy (eg 30/06/2013):", Default:=Format(WorksheetFunction.EoMonth(Date, -1), "dd/mm/yyyy")), "dd/mm/yyyy")
    If end_date = "" Then End
    
    Range("N10").Value = user_name
    Range("N11").Value = Oracle_password
    Range("D7").Value = end_date

End If

End Sub

Is the problem coming from the date format and how can I solve it so even if she has different date format to eventually run the report with the one I have.

Thank you in advance for the help.

Regards,