![]() If Not Intersect(Target, Range("C:C")) Is Nothing Then Private Sub Worksheet_SelectionChange( ByVal Target As Range) Replace this existing code with the following code. Step 10: In Visual Basic Editor, a code is already written. Step 9: Right-click on the date picker and choose “view code” from the contextual menu.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.Step 3: The Developer tab appears at the end of the Excel ribbon.In the option “customize ribbon” (on the left edge of the dialog box), click on the checkbox for the “developer” tab. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |