ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Calendar Control (https://www.excelbanter.com/excel-programming/357392-calendar-control.html)

Patrick Simonds

Calendar Control
 
Is there any way to lock a Calendar control in such a way that someone could
only select a Thursday? Ideally the last Thursday of the month.



Kevin B

Calendar Control
 
Wouldn't it be easier for all concerned if you put a list of last Thursday
dates in a named range and then use a data validation listbox that references
that range for date selection in the cell. It sure would save you a lot of
work.

--
Kevin Backmann


"Patrick Simonds" wrote:

Is there any way to lock a Calendar control in such a way that someone could
only select a Thursday? Ideally the last Thursday of the month.




Patrick Simonds

Calendar Control
 
I suppose you are right, but I like the idea of the Calendar control because
it presents a more finished look to what I am doing.


"Kevin B" wrote in message
...
Wouldn't it be easier for all concerned if you put a list of last Thursday
dates in a named range and then use a data validation listbox that
references
that range for date selection in the cell. It sure would save you a lot
of
work.

--
Kevin Backmann


"Patrick Simonds" wrote:

Is there any way to lock a Calendar control in such a way that someone
could
only select a Thursday? Ideally the last Thursday of the month.







All times are GMT +1. The time now is 03:39 AM.

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