+ Reply to Thread
Results 1 to 3 of 3

Combining Calendar and Userforms Calendars Controled by one

  1. #1
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Combining Calendar and Userforms Calendars Controled by one

    Good morning everyone,
    I am having difficulty combining calendars. I know that best way would be to add a Date Picker but the frame and format seems to be small, therefore I am using the Calendar Control from Excel.
    I have a main calendar that Controls the sheets. Module included:

    Please Login or Register  to view this content.
    Module:

    Please Login or Register  to view this content.
    I have multiple Userforms that will need to access this Calendar but the only work around I have been able to find online and others, is to add 2 other calendar to control all my information in my Userforms.
    I have a Userform that requires 2 date entries. So, one textbox being controlled by one calendar, and the other by another.

    Problem is I would like to have everything controlled by one Calendar and not to have to control everything separately.

    So this said:

    I have
    UserForm (frmCalendar) – Normal Sheet Control
    UserForm (frmCalendar2) – UserForm Control for first date entry
    UserForm (frmCalendar3) – Userform Control for second date entry.

    Problem is, sometime when a Userform is generated; it will add a date out of nowhere in a textbox that is supposed to be blank.

    Here are my Codes from the 2 Calendars controlling the userforms:

    UserForm (frmCalendar2):

    Please Login or Register  to view this content.
    UserForm (frmCalendar3):

    Please Login or Register  to view this content.

    Would there be a more easier way to control my dates with this type of calendars or I should I leave it as is...

    The reason why I am using mutliple calendar is to control the information being inserted in the individual textbox in the UserForms... If there is 2 textbox in one userform that requires dates then it will be individually controlled.

    :D

    Excel Noub
    Last edited by Excelnoub; 12-31-2013 at 09:58 AM.

  2. #2
    Forum Contributor Toonies's Avatar
    Join Date
    07-30-2009
    Location
    Newcastle, UK
    MS-Off Ver
    Excel 2016
    Posts
    503

    Re: Combining Calendar and Userforms Calendars Controled by one

    Hi look at this it may help you

    http://www.excelforum.com/excel-prog...ing-leave.html

  3. #3
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Re: Combining Calendar and Userforms Calendars Controled by one

    Thank you Toonies I might just keep my Calendars... He is kind of doing the same thing because in his Userform he has 2 calendar controls in one userform. I need to control my textbox separately.
    I guess my method works and also I have searched in other forum stating that it is not possible.

    I actually took this method from another site...Ozgrid of VBForum, I don’t remember.

    I will try to play around with it but for now I guess I will stick with multiple Calendars.

    Thank you,

    Excelnoub

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Calendar on Sheet and userforms
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-06-2015, 09:28 PM
  2. Customized Calendar using UserForms
    By thisisgerald in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-29-2012, 06:48 AM
  3. How can i remove shared calendar links from 'Other calendars'
    By L_ter in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 03-30-2009, 02:54 AM
  4. Auto Filter controled by a macro - simple question!
    By NigelMBailey in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-10-2007, 08:51 AM
  5. How to run a commandbar controled module inside a Macro
    By betty77 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-16-2006, 10:29 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1