Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Mar 2003
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    System Calendar (Excel 2000)

    I have a 3 date combo boxes on a worksheet for the user to select a day, month and year. The date information here is used to extract some data from an external database. Currently if the user selects an invalid date e.g. 31 Feb the user gets a run time error. Is there any way to link the combo boxes to the system date and time or to the outlook calendar.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: System Calendar (Excel 2000)

    You might wan't to have a look at the Calendar control as in the attached example.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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