Calendar Selection
I would like to have a cell validation with a calendar function. You've
seen it; someone clicks on cell and instead of getting a dropdown list, you have a calendar you can select from with month and years to change from. Once the user selects the appropriate date, it places that date in the cell. Can this be done?? |
Hi DNA,
See: http://www.rondebruin.nl/calendar.htm --- Regards, Norman "DNA" wrote in message lkaboutsoftware.com... I would like to have a cell validation with a calendar function. You've seen it; someone clicks on cell and instead of getting a dropdown list, you have a calendar you can select from with month and years to change from. Once the user selects the appropriate date, it places that date in the cell. Can this be done?? |
This worked great! One more question, is there some way to have the
Calendar automatically popup with the user's is on a particular? Right now they have to right-click the cell, I would like, when they come to a date cell I select, for the caledar to popup automatically. Thanks! |
Hi DNA,
DNA" wrote in message lkaboutsoftware.com... This worked great! One more question, is there some way to have the Calendar automatically popup with the user's is on a particular? Right now they have to right-click the cell, I would like, when they come to a date cell I select, for the caledar to popup automatically. Thanks! I think that Ron de Bruin's code already provides exactly this functionality. As coded, the calendar pops up in response to cell selection. --- Regards, Norman " |
Norman, I've gone back through the code and don't see where it
automatically pops up when the cursor is over a particular cell. The code I got was from Martin Green. |
All times are GMT +1. The time now is 09:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com