How to limit date range in calendar control?

Hi,

I need to limit the date range available/allowed to choose from in a drop down calendar created with calendar control 12 in excel.

The date range is given in two cells in the sheet. Min date in cell I5 and max date in cell J5.

Any suggestion of how to do this with a VBA code?


Right now, my VBA code looks like this:

Please Login or Register  to view this content.

Thanks!

Please use code tags. Forum Rule #3 describes why and how to do that

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Select your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button).

Something like this maybe

Please Login or Register  to view this content.

Add a similar check for the other date