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]

I don't know which ones are dates, but for instance, in the update code:

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

and in the Plaka code:

txtA = Format$(Sheets("Worksheet").Cells(y, 1).Value, "dd.mm.yyyy")

Only second code it’s enough. That’s all you made it legend <3 thank you so much for your patience and interest.

 

[RoryA]

Glad we could help.