Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Melbourne, Australia
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calendar function (EXCEL 2000)

    Hi All,

    I have searched the excel forum with no luck- I hope you can help.
    Is there a calendar function in Excel, something similiar to word?
    Or do I have to enter dates and so on.

    Thanks Kindly,

    Kerrie <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Calendar function (EXCEL 2000)

    If you're just looking for a quick way to enter today's date, [ Ctrl ] + [ ; ] will work. Just hold the Control button down and tap the semi-colon key.

    If you're looking for a one-button monthly calendar to pop-up on your screen, I know of two ways:
    1. A third party add-in program from www.add-ins.com called spreadsheet assistant has such a tool.
    2. In the system tray, just double click the system clock. Up comes a calendar. That's cheating and it's not excel.
    - Ricky

  3. #3
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Melbourne, Australia
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calendar function (EXCEL 2000)

    Hi Ricky,

    Thanks for the info. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Do you know of a way to insert a calendar,similiar to the calendar wizard in word?
    Jan, Feb, March etc a whole year.

    Thanks Kindly

    Kerrie <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  4. #4
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Calendar function (EXCEL 2000)

    Just found a way - but it is from another add-in program. I can't find what you need in Excel. The program is Power Utility Pack 2000 and it has a perpetual calendar. You can use it to insert a simple date, paste a picture of any calendar onto a sheet or create a new workbook formatted as calendars for any date ramge you choose.

    Available from: <A target="_blank" HREF=http://www.j-walk.com/ss/pup/pup2000>Click here!</A>
    - Ricky

  5. #5
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calendar function (EXCEL 2000)

    Hi Kerrie,

    You can use the Calendar Control if you like. You may have to set a reference to "Microsoft Calendar Control 9.0" in the VBE in order to use it. You might also try to choose the "Add more controls" option with the "Toolbox" toolbar. On my system it is in "C:Program FilesMicrosoft OfficeOfficeMSCAL.OCX". If it is not there you can put it there manually and restart your system and I believe Excel will recognize it.

    Here is some sample code dealing with it:

    <pre>Private Sub Calendar1_Click()
    Application.EnableCancelKey = xlDisabled
    If Calendar1.Day <= 7 Then GoTo 10
    If Calendar1.Day <= 14 Then GoTo 20
    If Calendar1.Day <= 21 Then GoTo 30
    If Calendar1.Day <= 28 Then GoTo 40
    If Calendar1.Day > 28 Then GoTo 50
    10 ActiveWindow.ScrollColumn = Calendar1.Day + 3
    Calendar.Hide
    End
    20 ActiveWindow.ScrollColumn = Calendar1.Day + 5
    Calendar.Hide
    End
    30 ActiveWindow.ScrollColumn = Calendar1.Day + 7
    Calendar.Hide
    End
    40 ActiveWindow.ScrollColumn = Calendar1.Day + 9
    Calendar.Hide
    End
    50 ActiveWindow.ScrollColumn = Calendar1.Day + 11
    Calendar.Hide
    End Sub
    </pre>


    This may not be the best or most efficient example of using it, but it seems to work for me.
    HTH,

  6. #6
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    St. George, Maine, USA
    Posts
    158
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calendar function (EXCEL 2000)

    Kerrie,

    MS Knowledgebase has an article containing ax Excel macro that may meet your requirements. I think I tested it a while back but still prefer the Word calendar template.
    <A target="_blank" HREF=http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q213795>click here</A>

    Good luck,
    Bob_D

  7. #7
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Calendar function (EXCEL 2000)

    Arraymeister <img src=/S/king.gif border=0 alt=king width=21 height=22> Bob Umlas has an array formula monthly calendar <A target="_blank" HREF=http://www.emailoffice.com/excel/arrays-bobumlas.html>here</A>, and his other array formula information there is very useful & valuable. I have attached a sample current month calendar for your convenience (with a couple of minor variations from Bob's document); you would have to copy the formulas and structure your monthly "start points" 11 more times to cover the year, but it also gives you some flexibility; for example, you could design a layout which always gives you the next twelve months including the current month, or five months before and six months after the current month, or the calendar year in which this month resides. (I didn't look very closely, but I don't think this duplicates the other responses.)
    Attached Files Attached Files
    -John ... I float in liquid gardens
    UTC -7ąDS

  8. #8
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    199
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Calendar function (EXCEL 2000)

    Kerrie,

    I have found Chip Pearson's calendar <A target="_blank" HREF=http://www.cpearson.com/excel/download.htm> here </A> does a great job. It is an excel file, not a popup, but I usually load it automatically when Excel starts. I f you use mm/dd/yy time formats it is great, however as an Aussie I use dd/mm/yy, and for this situation it has a little non essential bug which I have managed to correct.

    Good Luck!

  9. #9
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    Terneuzen, Netherlands
    Posts
    895
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calendar function (EXCEL 2000)

    Mike / All,

    Your Calender-control doesn't work for me. More in general, is this the same thing as the drop-down list 'foldout' calender we also get in e.g. Outlook (where Today has a red circle around it).
    If so, I'd be interested to get this working. If not, what if this calender control then AND how do I use the one I mentioned above?

    Thanks,

    Erik Jan

  10. #10
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calendar function (EXCEL 2000)

    Well, actually I misread the original post, as this is a control and not a function.

    You can use it by inserting it into a form much like a combobox, button, or other control. I use it to let the user select a date and then do something with what they selected.

    I have attached a small workbook with some simple code that will illustrate what it looks like.

    HTH,
    Mike
    Attached Files Attached Files

  11. #11
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Calendar function (EXCEL 2000)

    Bother. According to <A target="_blank" HREF=http://support.microsoft.com/default.aspx?scid=kb;EN-GB;q279098>MSKB 279098</A> "Microsoft Office 2000 Premium, Microsoft Office 2000 Professional, and the stand-alone version of Microsoft Access 2000 have a Calendar ActiveX control that you can use in Microsoft Office applications. However, you are not licensed to redistribute the Calendar control unless you own a licensed copy of Microsoft Office 2000 Developer Edition."
    -John ... I float in liquid gardens
    UTC -7ąDS

  12. #12
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calendar function (EXCEL 2000)

    That is a bother...however, I would guess that it would be OK if the user already had Office 2000 Pro.

  13. #13
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calendar function (EXCEL 2000)

    Actually, from the website:

    "Even though the Calendar control is included with Office 2000 Premium, Office 2000 Professional, and the stand-alone version of Access 2000, you cannot redistribute the Calendar control (MSCal.ocx) in a custom application unless you have purchased a copy of Office 2000 Developer Edition.

    If you do not own a licensed copy of Office 2000 Developer Edition but plan to distribute your application to users who own either Office 2000 Premium, Office 2000 Professional, or the stand-alone version of Access 2000, your application will work properly if the users have installed the Calendar control. "

    Seems to me that the first paragraph says no, then the second paragraph says "Oh by the way, if you do decide to go ahead and include it in your app, it will work!".

    Go figure!

  14. #14
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Calendar function (EXCEL 2000)

    Thanks. Since I have neither the Developers Tools nor MS Office 2000 anything, could I interpret this as meaning that if someone had those products and had a valid reason to distribute a VB or VBA application to me that required the control, they could send me both the application and the control ... or would that be illegal?
    -John ... I float in liquid gardens
    UTC -7ąDS

  15. #15
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Calendar function (EXCEL 2000)

    John,

    There is no problem in developing in the Developer's edition and distributing the code and all required controls. Chances are you have many of these controls already on your system. The problem is you are not licensed to include them with your developments, and you will find you cannot include the controls in any project you develop unless you have the required license registered on your system.

    Andrew C

Page 1 of 2 12 LastLast

Posting Permissions

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