Install Date Picker in two separate columns in Excel

Install Date Picker in two separate columns in Excel
install a date picker in a range of cells, install a date picker in two different cells.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With Sheet1.DTPicker1
   .Height = 20
   .Width = 20
If Not Intersect(Target, Range("D3:D10, F3:f10")) Is Nothing Then
   .Visible = True
   .Top = Target.Top
   .Left = Target.Offset(0, 1).Left
   .LinkedCell = Target.Address
   Else
   .Visible = False
   
End If
End With

End Sub


For more help visit my website https://www.easyexcelanswers.com

I am able to provide online help on your computer for a reasonable rate.

MY videos are all created on Camtasia.
http://send.onenetworkdirect.net/z/58...


Follow me on Facebook
Facebook: easyexcel.answers

• #howto_style
• #install_date_picker_in_two_separate_columns_in_excel
• #install_a_date_picker_in_a_range_of_cells
• #install_a_date_picker_in_two_different_cells
• #excel
• #date
• #two
• #picker
• #calendar
• #separate
• #columns
• #install
• #datepicker