Calendar Control 11.0

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

missing object library 2
Find Date cell using Calendar Control 1
Connected from Excel to Access 3
How do I delete a Calendar Control 11.0 from Excel worksheet? 1
what type is calendar control 6
Calendar Control Problems 2
Microsoft Word and Excel 11.0 Object Library 4
Compile error in query expression 2

Back
Top