ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Calendar Control - limiting min & max (https://www.excelbanter.com/excel-programming/341504-calendar-control-limiting-min-max.html)

Jennifer

Calendar Control - limiting min & max
 
Is there a way to limit the calendar control to go from a specific date to a
specific end date?

For example, I have the control that comes up when a cell is selected but
need the calendar to be limited from Sep 1 2005 through Dec 31 2006 (only
those dates available for choice).

Any input would be appreciated! Thank you!

Gareth[_7_]

Calendar Control - limiting min & max
 
You could limit it programmatically by responding to the user's selection.

Alternatively, I find DTPicker (Microsoft Date and Time Picker Control
in MSCOMCT2.OCX - you should have it) to be a nice date selection
control. It looks a lot neater than the calendar control and has MinDate
and MaxDate properties you can set.

HTH,
Gareth

jennifer wrote:
Is there a way to limit the calendar control to go from a specific date to a
specific end date?

For example, I have the control that comes up when a cell is selected but
need the calendar to be limited from Sep 1 2005 through Dec 31 2006 (only
those dates available for choice).

Any input would be appreciated! Thank you!



All times are GMT +1. The time now is 12:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com