Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar Control
Here's a simple one for you but I am befuddled........
I have a form with a Calendar. How can I get this calendar to be set to the current date when this form is opened? Right now it is opening to the date that I created the calendar. I have tried different things in the properties ... no luck. Thanks!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar Control
Here's a simple one for you but I am befuddled........
I have a form with a Calendar. How can I get this calendar to be set to the current date when this form is opened? Right now it is opening to the date that I created the calendar. I have tried different things in the properties ... no luck. How about this? Calendar1.Value = Date Rick |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar Control
Here is what I have but it is not working. The calendar still opens with the
date in which I created the calendar. The name of my Calendar is Calendar1. I have set the properties for the month, day, year, to be 0. Private Sub frmCalendar_Open() Calendar1.Value = Date End Sub "Rick Rothstein (MVP - VB)" wrote: Here's a simple one for you but I am befuddled........ I have a form with a Calendar. How can I get this calendar to be set to the current date when this form is opened? Right now it is opening to the date that I created the calendar. I have tried different things in the properties ... no luck. How about this? Calendar1.Value = Date Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calendar Control | Setting up and Configuration of Excel | |||
Control disappeared problem - specifically, the Calendar Control | Excel Programming | |||
Calendar Control | Excel Programming | |||
Calendar Control: Can't exit design mode because control can't be created | Excel Programming | |||
Calendar Control 10.0 | Excel Programming |