Hi All,
I've created the following Userform:
Userform.jpg
There are two things I am trying to accomplish. The first thing is to make the two textboxes force the user to enter the MM/DD/YYYY format. Alternatively, I'm also trying to give the user the option to click "Add Date" which will bring up the Calendar Control userform and then pick a date which will then be entered into the textbox in the MM/DD/YYYY format. Can anyone help me with the VBA coding for this?
Jeff
instead of using a text box, why dont you use a lable control, and then only allow the user to change the date using the calendar control. That way the format will always be correct.you can always use the intialize event to add todays date when the form is opened.
i dont have the infor on this pc, but might be able to provide some info later when i get home.
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
Here, i found one on a workbook which i have altered for this example
Works great. Thanks Sean!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks