How to add date picker in an Excel 2010 Table
Posted on 2015-02-18
Using: Excel 2010
I'm running into problems trying to get a date picker to work in an Excel 2010 Table.
I've gone as far as inserting the date picker object but am having difficulty applying the date picker object to the correct cell in my table.
I inserted the object via:
Developer > Insert > More Controls > Microsoft Date and Time Picker Control 6.0 (SP6)
I will need to use the date picker next to the active cell (imagine a behaviour similar to a drop down menu on a web page where the cell you pick remains visible and once selected, the Picker window opens up just below and to the right of the active cell) and the active cell could be any initially blank cell in a column, or could be a stand-alone cell, and could be on different worksheets within the workbook.
For clarity, I want the date which is entered to go only in the one active cell, not into several of them at once spread about the workbook.
I've tried various ways and always run into one snag or another.
So ... I can insert the Date Picker object but I don't understand how to format it correctly (size it), where to place it, and how to apply its pop-up behaviour to a target cell. The other issue I have is that I don't know how to turn off the display of the Date Picker object I inserted; I only want it to appear after a particular cell (which I designate as a target cell) is selected.