Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Range("A:A"), Target) Is Nothing Then
ActiveSheet.DTPicker21.Visible = 1
With ActiveSheet.DTPicker21
.CheckBox = 1
.LinkedCell = Target.Address
.Top = Target.Offset(0, 1).Top
.Left = Target.Offset(0, 1).Left
.Height = 17
.Width = 85
.Value = Date
End With
Else
ActiveSheet.DTPicker21.LinkedCell = ""
ActiveSheet.DTPicker21.Visible = 0
End If
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Set MyBut = Shapes("dtpicker1")
sr = Windows(1).ScrollRow
sc = Windows(1).ScrollColumn
MyBut.Top = Cells(sr + 5, sc).Top
MyBut.Left = Cells(sr, sc + 8).Left
End Sub
Copyright©1996-2021,Tapuz Media Ltd. Forum software by XenForo® © 2010-2020 XenForo Ltd.