Calendar Control 11.0

A

Adam

Dear All

I am using Excel 2003 and have inserted the object Calendar Control 11.0 but how can this link to anything? How can I use the date I select on the object in the spreadsheet in anyway


Adam
 
F

Frank Kabel

Hi
one way:
- in design mode double-click on the calendar object
- in the appearing VBA editor window insert the following code:
Private Sub Calendar1_Click()
ActiveSheet.Range("a1").Value = Calendar1.Value
End Sub
 
Top