i am using excel 2007.i am unable to change the date format after selecting the date from date picker as shown in the image. i tried to change the format by right clicking the excel cell but still not working. i am not that expert in visual basic but still i can do if i get any suggestion. visual basic code written is as follows
VBA Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With Sheet2.DTPicker1
.Height = 20
.Width = 20
If Not Intersect(Target, Range("a13:l28")) 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
Attachments
Last edited by a moderator: