Calendar control Excel

  • Thread starter Thread starter Louis L
  • Start date Start date
L

Louis L

I have a calendar control on a userform in excel. I want to put th
date from the calendar control into a cell on the spreadsheet. Tha
ok, it lets me do one cell, when I try to click on a different cell o
the spreadsheet, nothing happens. How can make the cells in th
spreadsheet active so I can click on a different cell to use th
calendar control to enter another date into a cell. :
 
Louis,

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Calendar1.LinkedCell = Target.Address
End Sub

Put this in the sheet module.
 
Back
Top