Dear Friends,
I spent time in searching but did not find what I am looking for.
I have an excell, that has a column "date".
I would like to make the data entry easy so when the user selects a cell from that column I would like a calerndar to pop up.
Can you suggest solution please?
Erkamu.
Last edited by erkamu; 04-26-2014 at 08:53 PM.
Please, I need your help!
Hello erkamu,
The attached workbook contains two modules: frmCalendar and CmdBtn_Class. These can be imported into your workbook. This calendar will save the date the user picks into the active cell.
This calendar also allows you to change to the date format. The date format uses the same format codes as in the Number Format dialog box.
The macro below needs to be added to the worksheet which has the "date" column. You will need to change the "date column", column "A", in the macro to match your column.
Please Login or Register to view this content.
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!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks