Date format!

[Reemet]

I haveing a headic of Date value in one day it is dd.MM.yyyy with is requered and enother day it reverse day and month and look lile that MM.dd.yyyy

I use userform and a calender control

and code is like that!

Please Login or Register  to view this content.

while entering the code to the spread sheet then there is a code like that

Please Login or Register  to view this content.

If you have a good advice i'll be really thankfull!

[:) Sixthsense :)]

Use VBA Format() function like this...

Please Login or Register  to view this content.

[Reemet]

OK ill try, but i think that the regional settings will messes it up!

[Reemet]

No its not Working!
if the the date is dd.mm.yyyy then it change it to mm.dd.yyyy
and if the date is mm.dd.yyyy then it change it to dd.mm.yyyy

with is not secure that the format will all ways be the same format!

[Richard Buttrey]

Hi,

Maybe you are confusing what is actually in the text box. Are you sure that it is a date serial number rather than a string of text?

[Reemet]

The value of textbox is probably string because there is "numers" with "." the Calendar control value is defenetly Date value shown with different formats!
I now placed code like that:

Im not so sure that will secure that the date will remain like that!

Please Login or Register  to view this content.

and take away any other formatting in future!

See if it works in longterm!

I will follow it up some time!