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.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
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)
Bookmarks