Erlandsen Data ConsultingCustom Calendar For Selecting Dates From User
This example workbook contains a simple custom calendar that can be used as a replacement for the MS Calendar Control that sometimes causes problems with missing references.
The example file is for Excel 2007 or later, but the solution will probably work in Excel 97 and newer versions.
Click here to download this file.
Updated: 2012-05-13 Requires: XL2007 File size: 46 kB
thank you very much for this!! Where in the code can I change the cells I would like to put the box in??
The dialog box will by default be displayed in the middle of the screen.
To change what cells that triggers the display of the dialog you have to edit the code in the worksheet module (e.g. Sheet1).