Dear Forum members,
I have a userform containing Textbox which sends date to Excel cell with a submit button. Whenever I write date in the textbox from Date 1 to 12, no matter whaterever month, the entry in the cell from textbox get flipped date to month & month to date. But from date 13th to 31st the entries go correct into the cell.
I formatted the cell with date format and even custom format (dd-mm-yyy). The problem remains the same, from date 1 to 12, it gets flipped in the cell from userform.
I have uploaded a sample Excel file with Userform to try.
Can somebody help me with this.
Regards,
Mukhtar
I have a userform containing Textbox which sends date to Excel cell with a submit button. Whenever I write date in the textbox from Date 1 to 12, no matter whaterever month, the entry in the cell from textbox get flipped date to month & month to date. But from date 13th to 31st the entries go correct into the cell.
I formatted the cell with date format and even custom format (dd-mm-yyy). The problem remains the same, from date 1 to 12, it gets flipped in the cell from userform.
I have uploaded a sample Excel file with Userform to try.
Can somebody help me with this.
Regards,
Mukhtar