AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Date picker excel 2007 free download1/27/2024 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. 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". It was so helpful to me, I hope I can pass on the favor. 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
Read More
Leave a Reply. |