Date Format Of User PC Changes Display format date of Excel File after update

Hi All ,

I have to update data into excel file via userform.
The file is place in shared folder for user to update respectively.

Issue here is Different PC/notebook has Global Setting on Operating System for Date Display
ie
M/d/yyyy
dd-MMM-yy
MM/dd/yyyy

But when i was developing the file i fixed the column (H) to d/m/yyyy

Issue 1 , when their PC setting date is d/m/yyyy , when they filled up the form , results the date will displays 22/5/2014 or 2/12/2013
** This is fine with me as then the Userform will pull the data of date correctly.

Issue 2 , when their PC setting date is m/d/yy , when they filled up the form , results the date to display as 5/31/2013 (in column H)

Issue 3 , when their PC setting date is dd-MMM-yyyy , they will face error when trying yo update the file using userform.
Current workaround was to asked them to change the date global setting to d/m/yyyy when updating the file , and can revoke setting
to their original after updating the myfile.

now the results in the file is in a mess , am not sure now if it display as 3/2/2013 (its 3rd Feb or 2nd March) .

Worst is when i query the specific results , since i slice the column into (3) data for date 5/31/2014 , so Month will take 31 into Textbox of userform after i click which data to edit from Listbox.


ComboAcceptDay.Value = Split(Listbox1.List(r, 6), "/")(0)
ComboAcceptMonth.Value = Split(Listbox1.List(r, 6), "/")(1)
ComboAcceptYear.Value = Right(Listbox1.List(r, 6), 4)

Any suggestion is most welcome on how to clear the mess in results data in excel.

is there a way irregardless global setting in user PC , when they update my file , the date is fixed displayed as d/m/yyyy ?

Thanks very much in advance.

Br ,
waiHar

hi Fotis , i just reply the post in the links , thanks for the suggestion , but i got stuck on the last line after adding, if i remark the last line it works well.
thats why i suspect its a max number there. for ListBox.

Hi Fotis , will you have any idea to advise on this posting of display format date. Seems to be no ones can help me here ?