Results 1 to 2 of 2
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Yilgarn region of Toronto, Ontario
    Thanked 0 Times in 0 Posts

    calendar control on WORKsheet (Excel97SR2)

    I've been playing around with the MSCal.OCX on user forms quite happily, and was wondering if one can add that (calendar) control directly to the Excel Control Toolbox. I have already achieved this with the Excel/VBE Toolbox. Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: calendar control on WORKsheet (Excel97SR2)

    You can use the "More Controls..." button on the Control Toolbox to add a Calendar control to a worksheet - when you click on Calendar Control in the list, the mouse pointer changes to a small cross. You can now click in the worksheet or drag a rectangle.
    But unlike the VBE Toolbox, the Calendar control will not be added as a new icon to the Control Toolbox, and as far as I know, there is no standard way to do so. You could create a macro with this instruction (plus error handling):

    ActiveSheet.OLEObjects.Add ClassType:="MSCal.Calendar"

    and assign it to a custom toolbar button on the Control Toolbox.

Posting Permissions

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