Select the Pearl or “ Office Button” in Excel.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. |