+ Reply to Thread
Results 1 to 4 of 4

Shrinking form

  1. #1
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Shrinking form

    I have a form containing a number of fields, standard inputs, a textbox and a couple of comboBoxes. Strangely, every time I open the form it shrinks in size, every part of it, its as if you've applied a zoom out so its getting further away. Ive scanned the code within it and there's nothing there to be a problem.

    It happens whether I open it via the menu option i created for it or directly from the VBA editor. Not only does it shrink when visible but the actual VBA form in Editor shrinks as well and the only way to restore it is to grab the bottom right corner and drag it down, as soon as you do it restores the size of the inner items.

    I'm not new to forms or VBA, I've done thousands in my time and never seen this before so I'm 99.99% confident its not something I've inadvertently done.

    Unfortunately I cant attach the workbook as just about everything in it is governmental sensitive (that makes me sound far more important than I am!)

    Any thoughts?
    If someone has helped you then please add to their Reputation

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,231

    Re: Shrinking form

    Aha... 007 You are. Yes, hrrmmm.

    Set the height & width parameters within userform Initialize
    Last edited by sintek; 04-01-2020 at 09:46 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Shrinking form

    hmmmm to be honest I'd not even thought of doing that but I'll give it a go however normally if you were to change the height and/or width the rest of the form would still stay the same just some of it wouldn't be visible? In this case it all shrinks.

    I'll report back

  4. #4
    Registered User
    Join Date
    05-03-2010
    Location
    New York, New York
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Shrinking form

    This is a vexing problem. I have a setup with my laptop connected to two larger monitors. This problem may be due to the different resolutions set for the laptop vs the big monitors.

    I have found that the user form shrinking seems to happen when I am using Excel with the VBE open for editing the user forms in one of the bigger monitors and I am in the Excel in the other big monitor. Here's one solution that seems to work for me: If I move the VBE back to the laptop, the problem seems to go away, maybe because the user forms are now in their "native" resolution.

    Once the sizes are correct again (and of course you don't need to edit the user forms anymore), closing the VBE in the laptop should make the user forms stop from mysteriously shrinking.

+ 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. Shrinking Buttons
    By JimBobBowie in forum Excel General
    Replies: 8
    Last Post: 07-12-2011, 08:12 AM
  2. shrinking pop up calendar
    By hugrl in forum Excel General
    Replies: 0
    Last Post: 01-19-2011, 11:04 PM
  3. Shrinking Listbox
    By Trybbe in forum Excel General
    Replies: 0
    Last Post: 03-25-2010, 03:14 AM
  4. Shrinking list box
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-15-2009, 11:58 AM
  5. Shrinking a design???
    By smarch001 in forum Excel General
    Replies: 2
    Last Post: 03-26-2009, 12:46 PM
  6. Shrinking controls
    By KD in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-26-2006, 05:25 PM
  7. [SOLVED] How to I past the exact copy of a form without it shrinking
    By Carol in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-31-2006, 03:40 PM
  8. [SOLVED] Shrinking Listbox
    By Francis Ang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2005, 02:05 AM

Tags for this Thread

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