VBA Macro to capture DATA in dd/mm/yyyy even though system date format is mm/dd/yyyy

Hi experts,

Could you pls help to write a excel vba macro to capture Data of Current Date in dd/mm/yyyy, even though my system date format is in different one. I am using excel/office 2007.

Thanks in advance,