+ Reply to Thread
Results 1 to 4 of 4

Changing the size of a userform

  1. #1
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Changing the size of a userform

    I am faced with the task of reducing the size of a group of userforms because of screen size limitations.
    Some of the forms are quite complex and I am wondering if it is possible to select the form and all its contents and reduce it proportionately. It is possible to do this with the form frame but I have not found a way to include the controls.
    Is there away ?
    I am sorry if I have chosen the wrong forum for this.
    John

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,626

    Re: Changing the size of a userform

    You can select all the controls (CTRL+A) on a form and resize them together but I'm not sure how it would turn out, especially if you were resizing different types of controls.

    Once you've resized all the controls satisfactorily then you could resize the form.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Re: Changing the size of a userform

    Thanks for the suggestion. It made a terrible mess! I have resigned myself to doing them manually
    John

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,241

    Re: Changing the size of a userform

    you can change the zoom setting of the userform
    Cheers
    Andy
    www.andypope.info

+ 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. Changing size of table
    By Lynild in forum Excel General
    Replies: 0
    Last Post: 06-06-2010, 05:13 PM
  2. Button changing size and font size
    By jennyc2 in forum Excel General
    Replies: 1
    Last Post: 05-13-2009, 07:53 PM
  3. Changing the size of a column
    By MrIrishExcelDude in forum Excel General
    Replies: 1
    Last Post: 01-14-2009, 06:07 PM
  4. Calendar in UserForm changing size
    By kvo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2007, 07:07 PM
  5. Changing text size in option buttons on a userform
    By Coen Burger in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2005, 05:05 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