+ Reply to Thread
Results 1 to 3 of 3

Userform size issue

  1. #1
    Registered User
    Join Date
    12-17-2012
    Location
    Dayton, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    31

    Userform size issue

    This is a cross post from another forum where I'm not making much headway.

    I have two userforms that I use to gather data from users for a prioritization model. One is for "early" projects that don't have as much detail and the other is for "later" projects who can answer a few more questions. They're designed to be "tall and skinny" so that users on a variety of systems can use them and just scroll vertically if their resolution is significantly lower than mine. Here's the developers view of the first form

    Strat_develop.jpg

    You'll note the width is set to 765. When I show the form it looks like this

    strat_show.jpg

    Which is fine.

    Here's the developer view of the second form

    tac_develop.jpg

    You'll note its width is 750...slightly narrower than the other form. When I show the form it looks like this

    tac_show.jpg

    It fills all of one of my monitors and spills over slightly onto the other...and even then not all of the controls are visible.

    I've tried the code here to dynamically resize the form and it makes it slightly worse...

    Any ideas on how to get the second form to display as nicely as the first one does?
    Last edited by jerH; 02-14-2015 at 07:27 PM.

  2. #2
    Registered User
    Join Date
    12-17-2012
    Location
    Dayton, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    31

    Re: Userform size issue

    Anyone? Bueller? Bueller?

  3. #3
    Registered User
    Join Date
    12-17-2012
    Location
    Dayton, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    31

    Re: Userform size issue

    Okay, so I've made some progress. I removed all code that did anything with resizing the form. I modified the design slightly to actually make it slightly wider so that the frames aren't butted right up to the border. And like magic, it works...on a single monitor system. But on a dual monitor system it gets truly screwy. The width is now fine, but the form is now too TALL to fit on the screen. Even with the vertical scrollbar, I can't get to the buttons on the bottom. This is despite the fact that the scrollheight is roughly double the height of the form. Additionally, when you scroll down the controls that are at the bottom of the form don't "appear" as they scroll onto the screen. So you scroll down and you see a big empty expanse of form...only when you click in it do the combo boxes, text boxes, etc. appear. I've found lots of threads on specifying the startup position of a form in a dual monitor setup, but nothing about missing controls.

    I'm attaching the actual file I'm working with in hopes someone can shed some light on this. I've now spent more time on getting this damn thing to display properly than I did building it in the first place.
    Attached Files Attached Files

+ 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. File size issue
    By penfold1992 in forum Excel General
    Replies: 14
    Last Post: 03-29-2012, 08:36 PM
  2. Header Size & Color (code issue)
    By GreatLakesJK in forum Excel General
    Replies: 0
    Last Post: 12-14-2010, 12:00 AM
  3. Don't Move And Size With Cell Issue
    By Evagrius in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-15-2010, 06:06 PM
  4. File size issue
    By NKRA in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-03-2007, 12:22 AM
  5. File Size issue
    By chivas in forum Excel General
    Replies: 0
    Last Post: 05-23-2005, 12:07 PM

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