How to fix Date format in VBA

[aksoni]

I want to restrict to enter data in a specified date format(eg: mm/dd/yyyy). i can control the display of date format but when i change this date again by double clicking it, then date format automatically converted in system date format. (I want to fix this date format, means it should not be on system depend date format)


Pl reply on my id as well: aksoni84@gmail.com

 

[xld]

Why? A date is a date is a date. As long as it is a valid date, what you see is just a presentation layer above the real value.

 

[vijaySharma]

Aksoni,


Welcome to Chandorg Forums...


You can get this done by checking the International Setting and then apply the desired format through VBA).


In your code you can check what is the current system default setting and change accordingly.

Dim lngDateFormatType as long

<p>lngDateFormatType = Application.International(xlDateOrder)

'Order of date elements:

'0 = month-day-year

'1 = day-month-year

'2 = year-month-day

The above variable will have 0, 1 or 2 depending on the System Date Settings... and you can then play with them to format as per your requirments.

HTH

~VijaySharma