Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi I've used the tutorial at www.fontstuff.com/vba/vbatut07.htm to set up a
calendar for date selection in a cell. I've used an earlier posting (12/5/2006 6:28 AM Calendar Control) by Tom Ogilvy to pick up the Friday of the week for any date selected. ActiveCell.Value = Format(Calendar1.Value - Weekday(Calendar1.Value, vbSaturday), "dd-mmm-yy") I'd like to know if it is possible limit the start and end years which can be selected from the Calendar, say 2003 - 2012. Can anyone help please? Regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Control disappeared problem - specifically, the Calendar Control | Excel Programming | |||
How do I add an extra day to a calendar every four years | New Users to Excel | |||
excel calendar years | Excel Discussion (Misc queries) | |||
excel calendar years | Excel Discussion (Misc queries) | |||
Calendar Control: Can't exit design mode because control can't be created | Excel Programming |