I have tested this and it works back to Excel 2003. Thanks again to Baodad for solving a problem caused by Microsoft's change from Excel 2007 to 2010 which prevented the previous pop-up calendar that worked in Excel 2007 to crash in 2010. Step 2: Add the Developer tab Right-click on any empty space in the toolbar. Otherwise, click on Blank workbook to create a new workbook. Step 1: Open your Excel workbook If you already have an existing workbook where you want a date picker, open that. In the attached version, a couple of adaptations to Baodad's original:ġ) Instead of double-clicking any cell to bring up the Pop-Up Calendar, pre-format to "d-mmm-yy", using a Custom Format, any cell for which you want a pop-up calendar to appear when the cell is clicked on (single clicked).Ģ) The code is set at the Workbook level, not the Worksheet level, so any additional sheets aded to the workbook will automatically have this capability as well. If you use a 64-bit version, skip to the next method. For 64 bit Excel, you can use either Sam Radakovitzs or Ron De Bruins Date Picker Add-in. I have attached, for you, and anyone else that wants to get the benefit of Baodad's good work (and my 2% adaptation), an Excel Workbook, with easy step-by-step instructions (for newbies like me) describing how to make this work in any other Excel 2010 Workbook. How can I get Microsoft Date and Time Picker Control installed on my 2016 Excel I am not seeing that option. Well, you did answer, and guided me to a way to adapt this to have what I wanted. Here's the sample workbook: /index.php?attachment/33067/ FilesĪfter asking you a couple of questions about this, I discovered this post was in a forum with the instruction "Do not ask any questions". You can either use it from the Ribbon to place a date value or a date range (if more than one cell. It was so helpful to me, I hope I can pass on the favor. I had run into this issue because Excel 2010 64 bit does not have a datepicker, which worked fine in Excel 2007/2003. A Datepicker independent of MSCOMCT2, also for 64bit Office. But I was once a beginner too, and I remember all the hours I spent trying to understand someone else's code. Unfortunately, this is a fairly advanced solution and it takes some understanding to suit it to your purposes. You need 1) code in the worksheet itself to bring up the date picker, 2) a userform with the date picker controls on it, 3) the clsCalendar class module code, and 4) another normal module just to hold a public variable so that all the other code modules can access it. But it turns out to be a little complicated to implement, as you will see when you look through the code. I'm attaching a sample Office 2007-2010 macro-enabled workbook that demonstrates the behavior you desired. In pre-Office 2007 versions of Excel, we could use a lot of tricks and APIs to remove a userform's title and borders, and make it look almost like it wasn't a userform, but it still needs to be a userform. This control depends on the functionality of VBA's userforms, so it really needs to be placed in a userform. Re: Non-activex Datepicker Calendar Control
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |