Opening calendar form with today's month & year

G

Guest

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?
 
C

Carim

Hi,

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

HTH
Carim
 
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Change Default Auto-Fill-In month 4
Excel Vba to change displayed year automatically. 14
Date picker scrollbar month and year only 19
How do I create a drop box in Excel to show a calendar? 1
Opening calendar (month view), I want today's date on top row 1
changing the month on an inserted calendar in excel 1
open with today at top of page 2

Top