Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 46
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 510
Default Opening calendar form with today's month & year

Hi,

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

HTH
Carim

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 46
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
holiday dates bucci Excel Worksheet Functions 4 June 15th 06 09:35 AM
How do I get Excel to automatically calculate salaries actually received in financial year? Kei Excel Discussion (Misc queries) 0 March 3rd 06 10:26 AM
Sort by Month and Year Yoshi Excel Discussion (Misc queries) 1 February 2nd 06 11:03 PM
Adding month and year to form date Dino Excel Discussion (Misc queries) 2 November 18th 05 01:59 AM
sort dates by day then month, not by year. Lisa Peterson Excel Worksheet Functions 5 July 12th 05 10:38 AM


All times are GMT +1. The time now is 05:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"