Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform Calendar - Current Date
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform Calendar - Current Date
try placing your code in the userforms intialize event:
Private Sub UserForm_Initialize() Calendar1.Value = Date End Sub -- JB "D" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter date in userform using Calendar Control | Excel Discussion (Misc queries) | |||
Convert date from Gregorian Calendar to Hijri Calendar | Excel Discussion (Misc queries) | |||
calculate prior calendar year end from a moving current date | Excel Worksheet Functions | |||
calendar highlight current date | Excel Discussion (Misc queries) | |||
Calendar date in UserForm | Excel Programming |