Replace this existing code with the following code. These scripts are primarily responsible for the creation and execution of macros in Microsoft software. Step 10: In Visual Basic Editor Visual Basic Editor The Visual Basic for Applications Editor is a scripting interface.

Step 8: In the “CheckBox” property, change the value from “false” to “true.” This allows the null values to be accepted.Step 7: Right-click on the date picker and choose “properties” from the list.Step 6: Click anywhere on the worksheet to create the drop-down calendar.Step 5: Choose “Microsoft Date and Time Picker Control 6.0 (SP6)” from the list and click “Ok.”.Step 4: In the Insert tab (under the Controls group), choose “more controls” from ActiveX Controls.This option was first introduced in the Microsoft Excel 2007. Step 3: The Developer tab appears at the end of the Excel ribbon Excel Ribbon The ribbon is an element of the UI (User Interface) which is seen as a strip that consists of buttons or tabs it is available at the top of the excel sheet.In the option “customize ribbon” (on the left edge of the dialog box), click on the checkbox for the “developer” tab. Step 2: A dialog box named “excel options” opens.Step 1: Under the “file” menu, choose “options.”.