date formatting in userform

i have a number of textboxes where i input dates or not but i would like dates to be DD/MM/YY not MM/DD/YY i dont fill all boxes so sometimes have blanks and when i fill in boxes a may delete date if that person no longer have
any help would be good

Please Login or Register  to view this content.

sorry i cant get it working if i use Cdate it works if i fill in the box but if that box is blank it showa error, its showing it right on the userform but not in excel sheet i have formatted the excel sheet to uk DD/MM/YY
this is what i have done to the code it really doing my head in i did try and upload file but did not work

Please Login or Register  to view this content.

i managed to download file if anybody can have a look at this if you need to login to my system the username is username and password is password
thanks

all codes i am using is from bits off the web so if you can see a better way that would be good thanks

http://www.ozgrid.com/forum/showthread.php?t=192541

can anyone help please? I have inserted an exemple above.
Thanks

thanks Norie that solution did not work

i would like to thank everyone that helped i have found the solution all i needed to do was change "DD/MM/YY") to "DD/MMM/YYYY") and it works perfect,