Date Format in Userform Textbox

Hi,

I'm having problems with date format in userform text boxes. I fill in the date in the text box and then when I ok it the date is stored in cell on the worksheet which is formatted to date DD/MM/YYYY. when I reopen the user form the date then repopulated back into the same text box but sometimes the format changes.

For example - if I enter 15/09/2017 in the userform, it appears this way in the cell and also in the text box when I reload it. If I enter 01/09/2017 in the userform it appears in the cell as 09/01/2017 so it looks like the format has changed.

The control panel has the date settings as UK and the date format is set in the cell so i think I have to change the formatting in the textbox but I'm not sure how to do this and if it should be when I initialize the userform, when I run th subs based on the userform or both.

there is more than 1 textbox in the userform that needs to do this but not all of them.

example of the code use on intializing is, PCard1 is the textbox:

Please Login or Register  to view this content.

Any help would be greatly appreciated

I've attached a picture of the userform. Each checkbox down the left activates a frame and I run a loop through each frame. I've pasted the first section of the code below as well, it just repeats for each frame. There's no doubt a more efficient way to do it but I'm pretty new at this. some of the textboxes use a date and some don't.

Driver List.JPG

Please Login or Register  to view this content.

I've updated the code for the OK button to load the info into the spreadsheet to:

Please Login or Register  to view this content.

it works fine when so the date format is in the worksheet as in the userform but when I reload the userform the format changes again e.g if I put 09/01/2017 in the userform it appears the same on the worksheet but when I reload the userform it appears as 01/09/2017.

the code when initializing the userform is now:

Please Login or Register  to view this content.

perfect. Thank you. Before using Cdate I was doing as you said but using .value NOT .text and had the same problem. Sorry if it was a schoolboy error