MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Setting todays date in Calendar control


Posted by Martin Nielson on November 19, 2000 12:40 PM

Is there a way to cause to current date to be set on the calendar control (Excel 97) automatically when the worksheet is "loaded" (or whatever). I have added code to set it upon a doubleclick event on the calendar itself after the worksheet has come up, but it sure seems that there must be a better way to do this.


Posted by Joe on November 20, 2000 7:28 AM

Martin,
I'm no expert on the calendar control, but this works for me. In the code window for the userform which contains the calendar, use something like:

Private Sub UserForm_Initialize()
Calendar1.Today
End Sub

HTH
Joe