Datepicker Help - Need to remove time from date picker

[rahulsteel]

Hello,

I'm using the following code below. However even time is displaying, can someone please help me, how do I remove time from this
Thanks

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

With Sheet1.DTPicker1
.Height = 20
.Width = 20
If Not Intersect(Target, Range("B:B")) 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

 

[DanteAmor]

Select properties from your dtpicker
Select Custom

select the type of format desired

Press OK