Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel calendar year resetting 2005 2006
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. |
#2
|
|||
|
|||
See answer in your other thread (programming)
-- Regards Ron de Bruin http://www.rondebruin.nl "whowatwerwyhow" wrote in message ... 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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
excel calendar??? | Excel Discussion (Misc queries) | |||
Where is the template for the 2006 calendar? | Excel Discussion (Misc queries) | |||
Help with Charting My Data -- | Charts and Charting in Excel | |||
Format an excel column as a date for a 5 day week for a year. | Excel Discussion (Misc queries) |