View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael[_10_] Michael[_10_] is offline
external usenet poster
 
Posts: 16
Default Repost: Calendar Control: Ron De Bruin

Hi Ron, the code below you posted earlier works great for
a whole column. How do I isolate it to one cell only,
say "d4", as I want the user only use the calender on one
cell.

Thanks,

Michael


Private Sub Worksheet_SelectionChange(ByVal Target As
Range)
If Target.Column = 4 Then
Calendar1.Left = Target.Left + Target.Width -
Calendar1.Width
Calendar1.Top = Target.Top + Target.Height
Calendar1.Visible = True
Else: Calendar1.Visible = False
End If
End Sub