| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set default date on calendar control
I use the Microsoft Calendar Control 11.0 userform in a macro. The calendar
defaults the selected date to the date that the macro was created. What property controls this? I'd like to set it to the current date. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set default date on calendar control
On Aug 5, 2:38*pm, Stephen Lloyd
wrote: I use the Microsoft Calendar Control 11.0 userform in a macro. *The calendar defaults the selected date to the date that the macro was created. *What property controls this? *I'd like to set it to the current date. the property you are looking for is 'Value', as I recall, you can set it like this... me.Calendar1.value = now theSquirrel |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set default date on calendar control
Thank you sir, I'll get it working when i get into the office.
"theSquirrel" wrote: On Aug 5, 2:38 pm, Stephen Lloyd wrote: I use the Microsoft Calendar Control 11.0 userform in a macro. The calendar defaults the selected date to the date that the macro was created. What property controls this? I'd like to set it to the current date. the property you are looking for is 'Value', as I recall, you can set it like this... me.Calendar1.value = now theSquirrel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ENTER A DATE USING CALENDAR CONTROL | Excel Discussion (Misc queries) | |||
| How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
| Calendar Control Changing System Date | Excel Programming | |||
| How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
| calendar/date control | Excel Programming | |||
![Stephen Lloyd[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
