Calendar control Excel

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. :
 
E

Earl Kiosterud

Louis,

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

Put this in the sheet module.
 
Top