VBA form interpret the data in the excel worksheet wrongly.

Question

What is the solution for date format in the excel VBA form? Im still new with the excel VBA. When I key in the date in the VBA form using this format [dd/mm/yyyy], it will interpret automatically as [mm/dd/yyyy] in the worksheet. My computer system settings for the date format is in [dd/mm/yyyy] and the excel date format is [dd/mm/yyyy] (I tried to put it as General and custom, both didnt work). Is there any solution for this? The VBA coding might help I guess.

Thanks in advance for the help guys!

Answer 1

When you write code in VBA, the only acceptable date format is US format. MSFT is a US company, and they got to choose.