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]

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

I wrote the problem in my first message.
The problem is; I makin search and get the datas to textboxes. There are 32 column and 5 of them are dates. I want to edit date with textbox and update. But when I press to date’s textbox and want to change date changes to “01.01.1900” and can’t edit.

 

[RoryA]

That sounds like a problem with your code, but you haven't posted it, other than one line, so it's very hard to comment.

 

[Tayl4n]

That sounds like a problem with your code, but you haven't posted it, other than one line, so it's very hard to comment.

Everything is worked clearly before I add this

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

This is solve only showing date formats.
I can’t copy paste the all codes because there is no internet connection. I wrote codes with phone and its hard which parts do you need to comment ?

 

[RoryA]

I need to know which event is reformatting the textbox. If it's the Change event, don't use that. Use something like the Exit event of the textbox.

 

[Tayl4n]

I need to know which event is reformatting the textbox. If it's the Change event, don't use that. Use something like the Exit event of the textbox.

Yes it is work I can change and update but date shows on textbox as this time “mm/dd/yyyy” and it is making possibility to mistake.

 

[RoryA]

You should only need to format it when you load the date into it.

 

[Tayl4n]

You should only need to format it when you load the date into it.

Yess that is exactly! But I don’t know alternative codes for format

 

[RoryA]

The Format code is fine, it's where you use it that is the problem. It should only be used in the code that populates the textbox initially with the date value and, if necessary, something like the Exit event of your textbox.

 

[Tayl4n]

The Format code is fine, it's where you use it that is the problem. It should only be used in the code that populates the textbox initially with the date value and, if necessary, something like the Exit event of your textbox.

code didn’t work in exit event also tried before update and after update there is mo results

 

[RoryA]

It's impossible for me to help you if I can't see the code you are using, I'm afraid.