Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With Me.Calendar1
If Target.Column = 2 And Target.Row > 1 And Target.Count = 1 Then
If Target.Offset(0, -1) <> "" Then
.Left = Target.Offset(0, 1).Left
.Top = Target.Offset(0, 1).Top
.Visible = True
Else
.Visible = False
End If
Else
.Visible = False
End If
End With
End Sub
Private Sub Calendar1_Click()
ActiveCell = Me.Calendar1.Value
End Sub
Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With Me.Calendar1
If Target.Column = 2 And Target.Count = 1 Then
.Left = Target.Offset(0, 1).Left
.Top = Target.Offset(0, 1).Top
.Visible = True
Else
.Visible = False
End If
End With
End Sub
Private Sub Calendar1_Click()
ActiveCell = Me.Calendar1.Value
End Sub