• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Date entry wrong via Userform

Mukhtar

New Member
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
 

Belleke

Well-Known Member
I can't see the userform.
But try:
Code:
Textbox1.value=Cdate(Textbox1.value)
Note,when you use Cdate the dates has to be filled,if not you have to add extra code.
 

vletm

Excel Ninja
Mukhtar
You should reread Forum Rules
You've skipped cross-posting.
 
Top