#1   Report Post  
whowatwerwyhow
 
Posts: n/a
Default excel calendar years

Hi,

I'm trying to use the calendar tool in Forms under the VBAProject so that
the years dropdown list only displays the years 2005 and 2006 (instead of all
years from 1900 thru to 2100). Is there a way to limit the years to only 2005
and 2006?

If not, is there a way to display an error message so that the user can be
told to enter a date between 2005 and 2006 if they don't? I've got a
validation check but this seems to have no effect when the date is entered
using the pop-up calendar tool.

Thanks in advance.
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
Excel Adding years or months to a date Joan Excel Discussion (Misc queries) 2 April 25th 05 08:09 PM
How Do I open an excel file without Excel Viewer support CocoriteBallGiants Excel Discussion (Misc queries) 2 February 4th 05 10:50 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM
How would I make a calendar template in Excel for the year 2006?? GHL Excel Worksheet Functions 5 January 21st 05 07:05 PM
Pop up calendar won't show in Excel 2000 Juls Excel Discussion (Misc queries) 1 January 6th 05 08:40 PM


All times are GMT +1. The time now is 09:22 PM.

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

About Us

"It's about Microsoft Excel"