Option Explicit
Private Sub DTPicker1_Change()
DTPicker1.TopLeftCell.Value = DTPicker1.Value
DTPicker1.Visible = False
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
DTPicker1.Value = Date
DTPicker1.Visible = (Target.Column = 8 And Target.Row > 3 And Target.Row < 8)
DTPicker1.Left = Target.Left
DTPicker1.Top = Target.Top
End Sub