First-pass translation, for those who don't read Portuguese:
Quote:
I have a problem that started recently and do not know how resolve. I have a system in excel VBA and this system saves certain data from a form on a spreadsheet that serves as a database. When it sends the data to the worksheet it saves the correct date format, which is dd / MM / yyyy, but when I do the search for data and make the change by adding another date, ie the date of the end, it's saved in MM / dd / yyyy—and where I live, in Brazil, this date is unacceptable. What can it be?
|
Laercio, three questions:
1) Is it VBA code that places the start date in dd/mm/yyyy? I mean, is the start date being placed in the worksheet by VBA code, or by some other method (such as by hand)? I'm not sure from your description.
2) Is it VBA code that places the end date in mm/dd/yyyy? I think you're saying it is.
3) Is it the
same VBA statement in both cases? Surely it isn't.
So what I suspect is happening here is that the VBA statement that's putting the end date in your worksheet is doing it wrong; either it's specifying mm/dd/yyyy, or it isn't specifying the format at all and the default format is wrong. To find out which you'll have to look at that VBA statement, and to fix it you might have to change that VBA statement. So the first thing is to find it and post it here. Do you know how to do that? I can't tell from your first post whether you can find your way around a VBA program.