I have prepared a small vba user form for entering the leave details. While entering the date in "From" and "To" fields (text boxes)in teh format dd/mm/yyyy, the data is written in the excel sheet as mm/dd/yyyy. Please help to rectify the error.
I am appending the script...
Please Login or Register to view this content.Please Login or Register to view this content.
Last edited by arlu1201; 11-04-2012 at 09:33 AM.
Try this Anilswarrier.
Please Login or Register to view this content.
Kind regards, Harry.
Wrap the values with DateValue or CDate.
By the way, you don't need the loop at the end.Please Login or Register to view this content.
Oh, and remember to format the date cells appropriately.
Last edited by Norie; 11-04-2012 at 08:52 AM.
If posting code please use code tags, see here.
Anil,
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks