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

hi,

I got an idea to store the date using NumberFormat in VBA macro.

 
sub entry_Date()
                 userform1.Ent_Dt.NumberFormat = Number
            ' the above code stores the date data in number format.
           end sub

           sub Date_format()
                  thisworkbook.Sheets("Sheet1").Range("A:A").Numberformat = "dd/mm/yyyy"
            ' this code converts the date data stored in numberformat to Date/Month/Year 
           end sub

I will try it to check ! Hope this works..... thanks for your guidence Holger.