MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Calendar results


Posted by Damien on August 01, 2001 4:39 PM

Have got a calendar form which is cool but can't return the result to a worksheet anyknow much about this ??


Posted by gregc on August 01, 2001 4:42 PM

Here's the code from one a calendar I have in an expense report.

Private Sub Calendar1_Click()
Range("d4") = Calendar1.Value

End Sub

Posted by Damien on August 01, 2001 4:52 PM

How do I Initialize the form i used Calendar1.today there is a button called select when they hit that this code runs
Private Sub cmdSelectDate_Click()

result = Calendar1.Value
Unload Me
Range("A1") = result
End Sub

help thanks

Posted by Gregc on August 02, 2001 7:42 AM

The way I have my calendar is that there is a button to open the calendar and when they click the date on the calendar it puts the date into a cell. When they double click the calendar it puts the date into the cell and it closes the calendar. All the those are events within the calendar object.