UserForm.Listview date changes when transferred second UserForm2.ListView

Hi all

I have a list of invoices on a UserForm1.Listview , I do some selections and move to my selections to the second UserForm2.Listview but the date format changes,

UserForm1.Listview data comes form an excel sheet which shows the date format as 04 June 2020 (04/06/2020) which is correct but when I transfer the data to UserForm2.Listview it changes to 06 April 2020 (06/04/2020)


Please see the attachement
Any idea why or is there a way to avoid this?

Hi

I tried in word format this time , I hope this will work.

many thanks

Third time lucky

I have attached a test version , when you open the attached excel, it will automatically open Excel User Form,

from the Listview1 you can bulk select the data by holding your SHIFT key and click the mouse then there is Select Invoices button when you click that it will list your selection on the above Listview2

then you will see that the date will change different format. basically days become month if it is up to number 12. How do fix this?

I hope I managed to explain

PS: in the coding section you might see some coding that were belong to buttons that i took out, so please ignore

thanks again

basically when you click the Select Invoice button this part of the code transfers the date from the Rapor Sheet to the Multi Sheet and I realised when the dates were transferred to the Multi sheet Column D ,it changes the format other way round so 04/06/2020 becomes 06/04/2020

Please Login or Register  to view this content.

thank you again for your interest

Originally Posted by rorya

You could use:

Please Login or Register  to view this content.

thank you very much, this worked perfectly. You are a legend