Hi
Hoping somene can help.
A userofrm was created for me and I believe it was created in America and as a result the date ,whilst it is entered in UK format, transfers to the spreadsheet in US format. I have tried the MDY in Text to columns but it does not work.
Does anyone have any suggestions please.
In the code that puts the date on the worksheet try using CDate or DateValue.
That should convert to a 'real' date which you can format as you like - it'll probably be UK format by default.
Please Login or Register to view this content.
If posting code please use code tags, see here.
Hi Norie
Thanks for responding both of those return a value of "False"
Any ideas?Sheet3.Cells(erow, 25).Value = UserForm2.tbxCycle1.Value = DateValue(tbxCycle1.Value)
oops sussed it sorry written the code wrong!
Thanks for the helpSheet3.Cells(erow, 25).Value = DateValue(UserForm2.tbxCycle1.Value)
Eh, this doesn't really look like the example code I posted.
It should be.Please Login or Register to view this content.
Please Login or Register to view this content.
Hi Norie
DO you know how i adapt the code below to do the same, i have tried but keep getting an error.
Many thanksPlease Login or Register to view this content.
So you want the date from the sheet in the textbox with the same format as on the sheet?
Please Login or Register to view this content.
Thats it worked perfectly thankyou Norie.
Hi Norie
Any idea why this would give me a runtime 13 error
Please Login or Register to view this content.
Should have said the text box is called "TextBoxMeetingDate"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks