Change symbol in value

[Crispy85]

Hi,

I let users put in a date in an userform.
They are now able to put in format 01.01.2016.
However i want excel to correct the . to /, so it recognizes it as a date.

After the userform is filled in, is there an way to change the dot to a slash?

So for example.
if date.value contains . then range("A1") = substitute . with / in date.value

Thanks for the help!

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Neil_]

If your text box or date picker is actually called 'Date', change it. Date is a reserved word.

To pass the value of a control in your userform called 'txtDate' :-

Please Login or Register  to view this content.

Format the cell as a date.

[Olly]

Something like:

Please Login or Register  to view this content.

[mikerickson]

If you put this in the user form's code module, it will make the correction as soon as the user entered the value.

Please Login or Register  to view this content.

[Crispy85]

Thanks all for the reply's!