Userform Calendar - Current Date

D

D

How do you get the Calendar to open with the current date selected. Here is
what I have but it is not working. The calendar opens with the
date in which I created the calendar. The name of my Calendar is Calendar1.
I have tried setting the properties for the month, day, year, to be 0.

Private Sub frmCalendar_Open()
Calendar1.Value = Date

End Sub
 
J

john

try placing your code in the userforms intialize event:

Private Sub UserForm_Initialize()
Calendar1.Value = Date
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

Top