Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Showing a Calendar on a form (Excel 97)

    I am using various forms where a date is required. Having the user type in a date into a text box is too messy and I would like for them to be able to click on a date from a calendar and have the selection stored as a variable. I have browsed the "so called" knowledge base and have come up with lots of unrelated crap. What should I be looking for, is it an Active X object, or am I way out of my league here?
    All info appreciated (except abuse!)

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Showing a Calendar on a form (Excel 97)

    Using XL97, I was able to create a userform and add the Microsoft Month View Control, version 6.0. You just click on a date in the calendar and the click event gives you that date. Unfortunately, it's not on the computer that I am currently using, so I suspect that the control came from a VB 6 installation. HTH --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Showing a Calendar on a form (Excel 97)

    Calender Control 8.0 is part of Office 97 but i think it isn't installed by default.
    Francois

  4. #4
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Showing a Calendar on a form (Excel 97)

    <img src=/w3timages/blackline.gif width=33% height=2>
    > Calender Control 8.0 is part of Office 97
    <img src=/w3timages/blackline.gif width=33% height=2>
    Only the professional edition, but...
    Good news! MS has a <img src=/S/free.gif border=0 alt=free width=30 height=15> one that will work. Read <A target="_blank" HREF=http://support.microsoft.com/default.aspx?scid=kb;EN-US;q170692>Q170692</A>, especially the download link in the middle of the page.
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  5. #5
    New Lounger
    Join Date
    Jan 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Showing a Calendar on a form (Excel 97)

    Thanks for your help. I did get what I wanted by installing VB6 and adding the Date and Time Picker control to the the toolbox. I was pretty pleased with myself until I took the program to work and discovered that I could not use that control unless I had a licence......Blah de Blah!! TYPICAL!! Your tip saved me from losing it and taking out my frustration with Microsoft on my collegues. I thank you and my collegues love you!

Posting Permissions

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