Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Calendar control

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    117
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I created a project in Excel 2000 using calendar control 9.0. I am now trying to run the program in Excel 2002 (XP) and messages that I am getting is that the calendar form is not available. When I go to add additional controls I can not find it in the list. Can I add a control in XP and if so where do I find this control. Thank you.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Todd

    Are you using this as an insertable object on a worksheet? Or as an active X control on a userform?

    Tom

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    117
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Active X control on a user form. Thank you.

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have 2000, but I would assume that the control would be standard in XP?
    I will help you the best that I can...

    You said that the calendar was not in the list of additional controls?

    First of all search your system folder for MSCAL.OCX by trying to set a reference to the control from tools, references...

    Make sure the file type filter is selected for ".ocx"

    You should not need to do this, but?
    Anyway, see if you even have the file.

    Tom


  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    117
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    All my .ocx files are in the system32 dir as I am running windows 2000 but the mscal.ocx is not there. I do not have it at all on my machine. Thanks again.

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have to run...
    Someone will be able to help you.
    For now, if the file "mscal.ocx" does not exist in your system folder, check your office folder as well.
    If the file does exist but is not registered, then click on run and type this in the textbox...

    regsvr32 mscal.ocx

    Click Ok.
    Should register the control.
    Hope I was able to help you.
    Tom

  7. #7
    Board Regular
    Join Date
    Feb 2002
    Posts
    117
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Tom. You got me going in the right direction. I found on on the web the latest copy of mscal.ocx and then extracted it to my winntsystem32 dir and then ran the regsvr32.exe c:winntsystem32mscal.ocx and then my problems were over. Thanks again. Todd.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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