ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,602
- Office Version
- 2007
- Platform
- Windows
Hi,
On my worksheet i type in a cell 01/04/2023 BUT when i leave the cell i see it change to 04/01/2023
I open my userform & for the date issue above i see the dat as 1/4/2023 in the Listbox
Onb the worksheet the date is in column E4 then down the page
Right clicking the worksheet cell & selecting format its shown as in screenshot
Please see screenshot for the date issue that i mention.
My goal is to code so when i type 01/04/2023 the worksheet DOES NOT change ^ also the uderform also shows 01/04/2023
Many Thanks
On my worksheet i type in a cell 01/04/2023 BUT when i leave the cell i see it change to 04/01/2023
I open my userform & for the date issue above i see the dat as 1/4/2023 in the Listbox
Onb the worksheet the date is in column E4 then down the page
Right clicking the worksheet cell & selecting format its shown as in screenshot
Please see screenshot for the date issue that i mention.
My goal is to code so when i type 01/04/2023 the worksheet DOES NOT change ^ also the uderform also shows 01/04/2023
Many Thanks