PRABHAKAR9020
New Member
Dear Sir/Madam,
I am having an excel file named "PS-1111", in which there is sheet named as "MDB" which is my data base sheet.
In this sheet MDB, there is column-G, in which i have to entered the date.
I have made the column-G setting as Date format along with data validation rule so that people may enter the date in DD-MM-YYYY format only.
However, different person computer have different date setting format (like MM-DD-YYYY or MM/DD/YYYY or YYYY-MM-DD etc) due to which they are getting confused, how to enter the date in this excel file.
Therefore, i want help from the forum on following points.
1. I want a vba code which check the computer date setting format and if it is in DD-MM-YYYY then it allow to open the excel file else if it gives message that "Your Computer Date format is not in DD-MM-YYYY. Kindly change the system date format for opening this excel file".
2. i want a vba code which change the computer date format as DD-MM-YYYY when they get message that their computer date format is not in DD-MM-YYYY.
Note: I will be highly appreciating if the code language would be simple as i am just beginner of VBA coding.
Thanking You
Prabhakar
I am having an excel file named "PS-1111", in which there is sheet named as "MDB" which is my data base sheet.
In this sheet MDB, there is column-G, in which i have to entered the date.
I have made the column-G setting as Date format along with data validation rule so that people may enter the date in DD-MM-YYYY format only.
However, different person computer have different date setting format (like MM-DD-YYYY or MM/DD/YYYY or YYYY-MM-DD etc) due to which they are getting confused, how to enter the date in this excel file.
Therefore, i want help from the forum on following points.
1. I want a vba code which check the computer date setting format and if it is in DD-MM-YYYY then it allow to open the excel file else if it gives message that "Your Computer Date format is not in DD-MM-YYYY. Kindly change the system date format for opening this excel file".
2. i want a vba code which change the computer date format as DD-MM-YYYY when they get message that their computer date format is not in DD-MM-YYYY.
Note: I will be highly appreciating if the code language would be simple as i am just beginner of VBA coding.
Thanking You
Prabhakar