Results 1 to 5 of 5

Thread: VBA UserForm Based Calendar Substitute DatePicker Control For All MSO Versions

  1. #1
    Junior Member
    Join Date
    Mar 2014
    Posts
    1
    Rep Power
    0

    VBA UserForm Based Calendar Substitute DatePicker Control For All MSO Versions

    Not sure if I am posting this in the right forum. If not, my apologies. I need to create a calendar userform. An activex command button would placed in a cell that when clicked it would call up the calendar. Running Office 2010 University. Does not contain datepicker control nor calendar control. Any guidance greatly appreciated.

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi pookster,

    Welcome to board!!

    See Calendar Control for all Versions
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  3. #3
    Member
    Join Date
    Jul 2012
    Posts
    55
    Rep Power
    13
    Cross post

    VBA Calendar

  4. #4
    Moderator
    Join Date
    Jul 2012
    Posts
    156
    Rep Power
    13
    Dear pookster,

    Please read forum rules regarding cross-posting.

    http://www.excelfox.com/forum/f25/me...1172/#post5326

  5. #5
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Pookster, you can also download the userform based calendar control from http://www.excelfox.com/forum/f10/no...ew-control-44/

    Instead of using an activex control command button to invoke the calendar, you can just right-click on the cell, and run the calendar from the contextual menu.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Ribbon DatePicker Calendar Control For Excel 2007-2010
    By Excel Fox in forum Excel Ribbon and Add-Ins
    Replies: 5
    Last Post: 10-12-2013, 11:23 AM
  2. Ribbon Calendar DatePicker Word 2007-2010
    By Excel Fox in forum Download Center
    Replies: 24
    Last Post: 09-23-2013, 09:07 AM
  3. Pop up calendar/control to select date
    By jeff in forum Excel Help
    Replies: 3
    Last Post: 07-26-2013, 05:04 PM
  4. Non-ActiveX Calendar / MonthView Control
    By Excel Fox in forum Excel Ribbon and Add-Ins
    Replies: 1
    Last Post: 07-18-2013, 09:14 AM
  5. FreezePane In A Userform SpreadSheet Control 11.0
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 05-15-2011, 05:49 AM

Posting Permissions

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