Date update overflow error ‘6’

[Tayl4n]

Dear MrExcel community,
I have a project search & update & add & delete can do.
There are 32 column and 5 of them is date.
When I search date format has changed automatically “dd.mm.yyyy” to “mm/dd/yyyy” and shows up to textbox with that wrong format.
I solved this with this code;

txtU.Text = Format(txtU, “dd.mm.yyyy”

But this time update functions are broken for date textboxes. When I try to change a date on textbox this error shows up and date changin randomly ex. I press 2 and date changes to “01.01.1900”.
I feel confused. I use these codes for update;

Sheets(“Worksheet”).Cells(y,1).Value = txtA

 

[Tayl4n]

Sheets(“Worksheet”).Cells(y,1).Value = txtU

 

[RoryA]

Assuming the date string in your text box is in your regional format, use:

Sheets("Worksheet").Cells(y,1).Value = CDate(txtU.Text)

 

[Tayl4n]

Assuming the date string in your text box is in your regional format, use:

Sheets("Worksheet").Cells(y,1).Value = CDate(txtU.Text)

I wrote these codes to initalize. When I search, date shows up as “mm/dd/yyyy”. I do not this format. Im trying to do “dd.mm.yyyy” and do this editable

 

[Tayl4n]

* I don’t want

Assuming the date string in your text box is in your regional format, use:

I wrote these codes to initalize. When I search, date shows up as “mm/dd/yyyy”. I do not want this format. Im trying to do “dd.mm.yyyy” and do this editable

 

[RoryA]

Date values are date values, formatting is a completely separate issue. You can simply set the NumberFormat of the cell to whatever you want.

 

[Tayl4n]

Date values are date values, formatting is a completely separate issue. You can simply set the NumberFormat of the cell to whatever you want.

Sir first of all thank you for your interest! But this part is the problem “
But this time update functions are broken for date textboxes. When I try to change a date on textbox this error shows up and date changin randomly ex. I press 2 and date changes to “01.01.1900”.
I feel confused. I use these codes for update;”. Dates comes to textbox as “dd.mm.yyyy” but ex. “13.02.2021” I want to change as “23.02.2021” and press only 2 on keyboard then date changin to “01.01.1900” every single number on keyboard changes date to illogical dates.

 

[MARK858]

2 is the 2nd day starting from 1st January 1900 so typing 2 in a cell formatted as a date will result in 02.01.1900 (not 01.01.1900 btw) if your cells format is dd.mm.yyyy, so they are not "illogical dates".

 

[Tayl4n]

2 is the 2nd day starting from 1st January 1900 so typing 2 in a cell formatted as a date will result in 02.01.1900 (not 01.01.1900 btw) if your cells format is dd.mm.yyyy, so they are not "illogical dates".

So how can I solve this problem?

 

[MARK858]

So how can I solve this problem?

What problem? typing a 2 in is giving the correct answer... type the full date.