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!