+ Reply to Thread
Results 1 to 2 of 2

Calendar in UserForm changing size

  1. #1
    Registered User
    Join Date
    08-11-2004
    Posts
    1

    Calendar in UserForm changing size

    Hello all. I have a problem with a calendar. I have added a calendar to UserForm, I sized it nicely to fit the form and added extra contrils to it. But every time I re-open the workbook were this form with a calendar is used, calendar changing it's size, that half of it is outside the form (cropped by form's borders), some controls are covered with a calendar and I cannot see them. I am pretty tired of resizing it back in VBA every time.

    Could anybody advise please how can I solve the issue and what could cause this problem.

    Thanks in advance.

  2. #2
    Forum Contributor
    Join Date
    01-24-2007
    Location
    Southampton, UK
    Posts
    137
    Not sure exactly what the problem could be, but it may be worth checking the Font type and in particular the Font size that is defined for the title of the calendar (TitleFont property) and for the days of the month (DayFont property).

    It's possible that when the User Form and calendar are loaded and displayed the size is re-adjusted to accomodate a larger font - this is just a guess though.
    Last edited by Loz; 02-02-2007 at 08:15 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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