Date Picker- having issues adding multiple date pickers to a spreadsheet

Question

I am using Excel 2016 and I'm having issues with the date picker function.

I need to add multiple date pickers to non consequent columns. Sometimes the drop downs disappear when I close and reopen the file and another time I had two working and when I attempted to add a third one they disappeared.

This is the first time I'm using this feature and I don't have any VB experience. 

I need some direction on how to get this feature to work consistently. Are there any known issues?

Also, are there any other options besides date picker? I need to provide this spreadsheet to a client and want to make it as easy as possible for them to complete the multiple date fields.

This is the coding I found online. 

Private Sub Worksheet_SelectionChange(ByVal Target As Range)   

  With Sheet1.DTPicker1   

    .Height = 20            

    .Width = 20            

    If Not Intersect(Target, Range("A:A")) Is Nothing Then

      .Visible = True

      .Top = Target.Top

      .Left = Target.Offset(0, 1).Left

      .LinkedCell = Target.Address

    Else

      .Visible = False

    End If

  End With

  With Sheet1.DTPicker2   

    .Height = 20            

    .Width = 20            

    If Not Intersect(Target, Range("E:E")) Is Nothing Then

      .Visible = True

      .Top = Target.Top

      .Left = Target.Offset(0, 1).Left

      .LinkedCell = Target.Address

    Else

      .Visible = False

    End If

  End With

  With Sheet1.DTPicker3   

    .Height = 20            

    .Width = 20            

    If Not Intersect(Target, Range("H:H")) 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

Answer 1

Thanks Nick

I will post my question there.

Carla

Answer 2

Hi Carla,

Your concern regarding Date Picker in Excel is more complex than what is typically answered in the Microsoft Answers forums. It is better suited for the IT Pro audience on TechNet. Please post your question in the TechNet Microsoft Office forum. Kindly visit the link provided here: Microsoft TechNet - Ask a question.

Let us know if you need further assistance.