- Date Picker Option Missing On Microsoft Word 2016 File
- Date Picker Option Missing On Microsoft Word 2016 Free
Double-click the date picker, text box, or expression box control that you want to use to display the date. In the Control Properties dialog box, do one of the following: If you are working with a text box control or a date picker control, click the Data tab. If you are working with an expression box control, click the General tab. The Date and Time Picker is part of a library of tools with the catchy title of MSCOMCT2.OCX. To start with, you'll need to download this file from the Microsoft support site. Click this link on the page to start downloading the file.
- How to Install Microsoft Date & Time Picker Control 6.0 (SP4) In the posting “ Insert a Drop Down Calendar Menu In Excel – Choose a Date! ” one of the steps requires that you select the Microsoft Date & Time Picker Control 6.0 (SP4).
- How can I get Microsoft Date and Time Picker Control installed on my 2016 Excel? I am not seeing that option. And you find that this control is missing, you will.
- The control element 'Microsoft MonthView Control 6.0 (SP4) can also not be found under other controls. The nice thing about the Date and Time Picker is that you can provide a date input field with little effort, which always delivers a date as the result. Display the form in the VB editor.
In Microsoft Word 2016, the Developer tab provides different tools such as Codes, Add-ins, Controls, Mapping etc. The Developer tab is not visible by default, but you may add it to the tab’s list.
Also read: – How to insert an Excel sheet to Microsoft word
To display the developer tab, do the following steps:
- Click on the “File” tab.
- Click on “Options”.
- Click on “Customize Ribbon”.
- Under the right section i.e. “Customize the ribbon”, enable the check mark on “Developer”.
Now, the Developer tab will be visible. Click on “Developer” tab.
In order to create fillable forms, the following example (with detailed steps) will show you how to use various content controls such as Check Box, Combo Box, Drop down list and Date Picker in Microsoft Word 2016.
Step 1:
For using Check Box, enter a desired statement in your form and then click on “Check box Content Control” located in the ribbon toolbar.
For instance, we have entered a statement which is “Would you like to exit?” with a check box content control.
Step 2:
For using Date Picker Content Control, enter a desired statement for date in your form and then click on “Date Picker Content Control” located in the ribbon toolbar.
For instance, we have entered a statement which is “Enter a date” with a Date Picker Content Control.
Step 3:
For using Combo Box Content Control, enter a desired statement in your form for choosing a particular item and then click on “Combo Box Content Control”.
For instance, we have entered a statement which is “Choose your favourite color” with a Combo Box Content Control.
Step 4:
For using Drop-Down List Content Control, enter a desired statement in your form for choosing a particular item and then click on “Drop-Down List Content Control”.
For instance, we have entered a statement which is “Pick any animal” with the Drop-Down List Content Control.
Step 5:
Now, as we have entered all content control options, we need to save the file as a “Template”. For Saving the file, click on “File” tab positioned at the upper left corner of the Word Document window.
Step 6:
Click on “Save As”.
Step 7:
Choose a desired location to save your file. Enter a file name and choose to save the file as “Word template” given in the drop down list.
Step 8:
Click on “Save”.
Step 9:
In the Developer tab, click on “Design Mode”. The design mode will fill the suitable data (Form Options) to be selected as a choice by the user.
Step 10:
For the Check Box Content Control, right click on the middle of the icon and click on “Properties”.
Step 11:
If you wish to change the symbol of check box, make the necessary changes in your desired form and click on “OK”.
Step 12:
For the Date Picker Content Control, right click on the middle of the icon and click on “Properties”.
Step 13:
Choose an appropriate format for entering date in your form. Click on “OK” after making your desired changes.
Step 14:
For the Combo Box Content Control, right click on the middle of the icon and click on “Properties”.
Step 15:
Click on “Add” to fill a number of choices. After filling the choices, click on “OK”.
A user can select from the given choices or he/she can a fill a choice which is not included in the Drop-Down list.
Step 16:
For the Drop-Down List Content Control, right click on the middle of the icon and click on “Properties”.
Step 17:
Click on “Add” to fill a number of choices. After filling the choices, click on “OK”.
A user can select only a single choice from the number of choices in the Drop-Down list.
Saurav is associated with IT industry and computers for more than a decade and is writing on The Geek Page on topics revolving on windows 10 and softwares.
Related Posts:
Have you ever wanted a calendar to show next years date? It’s easy and convenient in most of the cases.
It can be a headache to maintain the data integrity when you are working with bigger and shared Excel worksheets. Especially, entering dates can become a nasty work. It always confuses the people if they should be mm/dd/yy or dd/mm/yy or mm-dd-yyyy? Or can you type a date like “10 Oct 2018”? Oh, and what would be the date of the third Friday in October this year?
Adding a drop down calendar in your excel sheet can solve these problems. A drop down calendar allows your users to fill the dates on a click of mouse. This guide shows you a trick that might work for you and save you tons of your time.
Before we start, you have to make sure the developer tab is available. If the developer tab is not already available in your Excel ribbons, you can follow these steps.
The first thing you need to do is click on the file in the top left of your screen and select “Options” at the very bottom of it.
Date Picker Option Missing On Microsoft Word 2016 File
This opens a new “Excel Options” box with bunch of options to select. Now click on “Customize Ribbon” which will bring out some more settings.
You should check the “Developer” option in the right hand box, under main tabs.
TADA! Now you have developer tab in your Excel ribbons. This is where all the magic is going to happen.
Now that you have the developer tab, let’s jump right into creating calendar and using it as a date picker.
In the developer tab, click on insert and go to the very bottom, where it says more controls. More controls allow you to insert a control from the set of controls available on your computer. The control we are going to use is available by default.
Once you click the more controls it open a new box with a list of options. In the list, scroll down the Microsoft date and time picker and select it.
Now you need to place the calendar somewhere on the screen. So select some part on your excel sheet and place it.
In the next step, turn off the design mode under developer tab. Now when you click on the little arrow it will bring out the calendar.
If you want to use calendar as a date picker you need to take a few more steps. Don’t worry we are almost there.
Now, turn back the design mode on again and click properties under developer tab. Under the properties click on LinkedCell and enter the cell number of your date. In my case which is B2.
Once you have assigned the date cell, turn off the design mode off again.
Now when as you pick the date from calendar it changes the date in your assigned cell.
Date Picker Option Missing On Microsoft Word 2016 Free
This way you can share your excel sheet with other users and they can pick a date from calendar to fill the dates.