userform textbox date save problem

[born2be]

i have the problem in my user form my textbox100 when i put any date like example 08/05/2016 (dd mm yyyy)
is see is also in the cell the same 08/05/2016 thats ok
but if i save or close the userform then it changes in the cell to 05/08/2016 ????

how to get it right so the cell stays on dd/mm/yyyy
my region settings are good in the worksheet it is set as (dd/mm/yyyy) an set right county i live in belgium so it set to dutch standard
is it the userform that has to change?

[BadlySpelledBuoy]

I tend to use something like:

Please Login or Register  to view this content.

But for a more specific answer we'd need to see the workbook and UserForm.

BSB

[rorya]

FYI, you shouldn't use Format, just CDate. Format will return a string which is what causes the original problem. Formatting should be done through the cell's NumberFormat property.

[born2be]

thanks for the tips

with numberformat did the date good again