+ Reply to Thread
Results 1 to 3 of 3

How to limit date range in calendar control?

  1. #1
    Registered User
    Join Date
    03-02-2012
    Location
    Bergen, Norway
    MS-Off Ver
    Excel 2007
    Posts
    18

    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!
    Last edited by Siglen; 03-05-2012 at 06:18 AM.

  2. #2
    Forum Contributor johnjohns's Avatar
    Join Date
    11-19-2007
    Location
    Dubai, UAE
    MS-Off Ver
    2003 and 2007
    Posts
    526

    Re: How to limit date range in calendar control?

    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).
    regards

    johnjohns

    When you are not sure where to go, every road takes you there!

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: How to limit date range in calendar control?

    Something like this maybe
    Please Login or Register  to view this content.
    Add a similar check for the other date
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1