ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Opening calendar form with today's month & year (https://www.excelbanter.com/excel-discussion-misc-queries/122896-opening-calendar-form-todays-month-year.html)

pkeegs

Opening calendar form with today's month & year
 
I am using a calendar form which opens on todays date. But is there any way
that I can have it so it opens on today's date, month and year as default?

Carim

Opening calendar form with today's month & year
 
Hi,

I am assuming you are using the Calendar object ...
Calendar1.Value = Date

HTH
Carim


pkeegs

Opening calendar form with today's month & year
 
Yes, but it doesn't show the current month or year unless they have first
been set in the properties box. Or am I missing something else?

"Carim" wrote:

Hi,

I am assuming you are using the Calendar object ...
Calendar1.Value = Date

HTH
Carim




All times are GMT +1. The time now is 08:16 PM.

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