Hi
I know this is a common problem. but i have tried solutions and they haven't worked for me or I havent been able to use them effectively.
My problem is that I have a userform which enters data into excel, it has the option to search and update the data.
When it comes to either entering new data or loading previously entered data, my data comes in american format "mm/dd/yyyy" but I need it to be in uk format "dd/mm/yyyy".
Please Login or Register to view this content.
Hello rayexcel,
VBA is notoriously "American" and causes all sorts of problems when using it internationally. It looks like you have converted the TextBox input to the correct date format. You also need to make sure the cell format is set to the same date format. Did you format your date column?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
When reading from the worksheet try using Text instead of Value for any date values.
When writing to the worksheet try using CDate or DateValue to convert the text date from the textbox to a 'real' date.
If posting code please use code tags, see here.
HeyInKy
You really should start your own thread.
Hey Norie
with the CDate/DateValue where and how would I place that
So therefore in my find sub, I would use
Please Login or Register to view this content.
Hey Leith
Yes my date column is formatted in "short date" format
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks