I have a form created through vba in which I need the user to enter the delivery date in the “dd/mm/yyyy” format. I need the same format to get uploaded to the excel sheet in the backend, which is linked to the form columns.
However, in the excel file, the format is automatically getting changed to the “mm/dd/yyyy”. The date formatting in the excel file is correct. I have cross checked the custom format for the column which stores the dates. I have passed the following code behind the delivery date column in the form.
Private Sub Del_Date_AfterUpdate() Del_Date = Format((Del_Date), "dd/mm/yyyy") End Sub