The first thing you need to do is enable the Developer Tab in Excel. Would you like the easiest, cheesiest, sleaziest way to do this? Well then watch this: I assume you just want someone using the spreadsheet to be able to select a cell, have a calendar drop down and then populate the field with whatever date the person chooses. This seems like it would be so easy yet when you look around on-line the answers are all full of VBA scripts and custom code. I want to have a cell formated so that I can have a pull down menu of a calendar in which to choose the date. I am sure that I saw a pull down menu in a worksheet cell. How do I insert a calendar as a way for a user to click on the cell have the date box open and choose the date that should be in the cell? Also where do I send the beer? So you want to create a drop down calendar in Excel? Apart from sending alerts to Outlook from Excel (working on that article as well) this has been the most requested how-to as of late.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |