The Datepicker in Word would be ideal as it has a dropdown arrow to select the date but the default text is 'Click here to enter a date' I note that if I use your calendar to insert a date, an icon will appear for users to very simply change the date, however this document will be of a legal nature and may end up as evidence in court proceedings etc, so I cannot have an old/incorrect date in the cell as a default for situations where no entry was required, as it would look like that date had actually been selected.Īlso, is there a way to choose 'longform' dates such as Saturday rather than 3/5/14.Īgain, thanks for your program and your online support. The form has about 20 or so cells that involve selecting a date to include. Select All Tabs from the Choose command from dropdown box and select Developer from the Main Tabs listbox. In the Excel Options Dialog, click Customize Ribbon from the left sidebar.

I am creating a Business User Form that must be functional for people with various computer knowledge. How to show developer tab in Microsoft Excel 2016 Ribbon 1.

Is there a way to put a dropdown selector for your calendar in a cell so end users can simply click to enter date in that cell, much like the active x control in Office.

Rod Ritchie Hi, and thanks for your program.

Where is the tools menu in excel 2016