Date format in excel vba

[LaercioNB]

Hello good day.



I have a problem that started recently and do not know how resolver.tenho a system in excel VBA and this sitema save 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 I make the search for data and make the change by adding another date ie the date of the end he saved in MM / dd / yyyy and how I live in Brazil this date does not serve. What can it be?