Text box is changing date format
Good Afternoon Folk
I have a spreadsheet where a userform is used to insert information.
In a text box the date is inserted dd/mm/yyyy however on the spreadsheet it is showing as mm/dd/yyyy.... how can I get the firrst format to appear on the sheet please
many thanks
Last edited by JamesT1; 05-13-2011 at 01:17 PM.
VBA always works with dates in US format.
Try something like this:
Please Login or Register to view this content.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Hi Domski
Thanks for that,,, I'm still new to VBA and have tried inserting your code , to no avail,, below is the code I am using can you show me where it would go please,,,,,
Please Login or Register to view this content.
It'll be like this:
Please Login or Register to view this content.
Dom
Domski
many thanks for your help,,, salved the problem for me
Jim
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks