LinkBack URL
About LinkBacks
How to create a drop down monthly date calender in excel? I have seen few videos in youtube different ways of doing this. What is the best way to do this?Any help greatly appreciated
How to create a drop down monthly date calender in excel? I have seen few videos in youtube different ways of doing this. What is the best way to do this?Any help greatly appreciated
attached is a file with a calendar form embedded in the VBE. There are three formats available. Click on Alt F8 to run each one.
Let me know if that works for you
Alan
Have you debugged your code?
Database Normalization
Database Principles
Move Data from Excel to Access
What is Power Query
Many thanks, I opened your sheet but what are the steps to add a drop down calender? Sorry, I am bit amateur in this regard
@bananacitizen
You will need a bit of VBA if you want an automatic pop-up in specific cells
Here is a simple example
- Test in attached file (alansidman's file with code below added)
- Select any cell A2 to A100 and (basic calendar) pop-up appears
- To find the code RightClick sheetTab \ ViewCode
Please Login or Register to view this content.
Last edited by kev_; 04-17-2018 at 10:45 AM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
@alansidman - thanks for sharing - very useful (and circumvents the regular issue with MSWindowsCommonControls)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks