How Can I Make my Excel Calendar Appear Automatically When the User Enters a Cell?
My tutorial A Pop-up Calendar for Excel shows how to build a pop-up calendar that can be saved as an Excel Add-In, or as a macro in an Excel workbook such as Personal.xls. The project includes code to make the calendar appear when the user right-clicks on a cell and chooses Insert Date from the context menu. But there are other ways to make the calendar appear, and one is to have it appear by itself when a specific cell is selected.
