LinkBack URL
About LinkBacks
I have a data entry file with a userform to enter the data. I would like to use a calendar (date picker) to enter the dates, there are two fields. Any help appreciated
I have a data entry file with a userform to enter the data. I would like to use a calendar (date picker) to enter the dates, there are two fields. Any help appreciated
The following link may help you. See Function 'LjmGetDateUsingCalendarForm()' in Sub 'TestCalendarForm()'.
See http://www.excelforum.com/excel-gene...ml#post3443599
Lewis
Try this..
Hello Nick,
I created a Calendar awhile ago that allows you to select the object you want the date to be displayed in. I have modified your workbook to use this Calendar. The user can either enter a date in TextBox1 manually or Double Click it to display the Calendar. Try it out and let me know what you think.
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!)
Nice work Leith.
Its rather involved though. I usually use the Calendar Control 12 which is a lot easier to use.
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!
Thanks guys for all your efforts, solved my issue, thanks again
Hello nickhunt,
Glad I could Help.
@ Sean,
The advantage this calendar has is works with all versions of Office. It also has the unique ability to direct the output to some other object than a Worksheet cell.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks