ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Calendar Control (https://www.excelbanter.com/excel-programming/406596-calendar-control.html)

D

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!!!

Rick Rothstein \(MVP - VB\)[_1327_]

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


D

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




All times are GMT +1. The time now is 07:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com