Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Jan 2003
    Location
    Denver, Colorado, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to make user forms sizeable (Excel 2000)

    I can't seem to find the way to make user forms sizeable. Mine only have the "X" close button in the upper right corner. How can I get the Max and Min, plus allow me to drag the form to any size I want?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: How to make user forms sizeable (Excel 2000)

    It isn't possible, except perhaps by using a massive amount of Windows API calls and spending a lot of time. UserForms weren't designed for this. If you really need resizable forms, write your application in something like VB6.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to make user forms sizeable (Excel 2000)

    Check out my flexfind, which has a button that changes the size of the form.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to make user forms sizeable (Excel 2000)

    Have a look at the attached file...
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: How to make user forms sizeable (Excel 2000)

    Hello Jan Karel,

    Nice demo, but there are some problems (at least in Excel 97 SR2):
    <UL><LI>I can drag the "resize" button up all the way until it disappears in the title bar of the window.
    <LI>When the form reaches its minimum width, I can still move the "resize" button to the left. Most of the time, I get an error message when I try to drag it past the left edge or the window, but sometimes I can make it disappear.
    <LI>While resizing, the form is not always redrawn correctly.[/list]The first two problems can probably be remedied easily by building in some checks to prevent Left and Top of the button becoming too small. The third problem might be caused by my video card, so I wouldn't worry about that.

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to make user forms sizeable (Excel 2000)

    Hi Hans,

    Thanks for your comments.

    Indeed this demo isn't quite finished yet. But I just thought to post it anyway and leave it to the original poster to decide whether or not to use it <img src=/S/smile.gif border=0 alt=smile width=15 height=15>.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: How to make user forms sizeable (Excel 2000)

    <P ID="edit" class=small>(Edited by Leif on 13-Mar-04 17:03. to update link to http://www.bmsltd.ie/)</P>If you are comfortable with API calls and Class Modules, Stephen Bullen has a sample file (Resizer.zip) at his Excel Page , which you can download and examine.

    Andrew C

Posting Permissions

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