+ Reply to Thread
Results 1 to 3 of 3

Change Multipage & UserForm size based on response

  1. #1
    Forum Contributor
    Join Date
    08-16-2012
    Location
    Sefton
    MS-Off Ver
    MS Office 365 ProPlus
    Posts
    131

    Change Multipage & UserForm size based on response

    I have a userform with a multipage, i'm looking to make the multipage (and therefore also the userform) extend in height if the value of a response increases.

    Currently my Useform Height value is 543 and the Multipage Height value is 438 - this gives me approx 5 rows of data within the Multipage based on my current layout.
    There's going to be a spin button on the form which will allow the user to increase the rows of data available (max 24). With every increment I want the form to extend in height if possible.
    Although for any number of rows less than 5 the form needs to have minimum heights of the values stated above.

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,910

    Re: Change Multipage & UserForm size based on response

    I have assumed that SpinButton1 has values from 1 to 24 - change the h = 10 to the amount that you want to change the height by

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Forum Contributor
    Join Date
    08-16-2012
    Location
    Sefton
    MS-Off Ver
    MS Office 365 ProPlus
    Posts
    131

    Re: Change Multipage & UserForm size based on response

    Thanks, that was a great help.

+ 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. how to switch multipage page from multipage change event??
    By jed38 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-27-2015, 10:31 AM
  2. Change color for pages in multipage on userform
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2015, 03:27 PM
  3. [SOLVED] Change tab forecolor multipage UserForm
    By john55 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2014, 06:08 AM
  4. [SOLVED] Change position of Multipage on userform
    By johnny_p in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-19-2014, 05:43 PM
  5. [SOLVED] Userform_initialize, select Multipage tab based on which previous userform button pressed?
    By jonathan@ibbotsons in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-06-2013, 01:58 AM
  6. [SOLVED] Change background image on individual multipage userform pages using vba
    By sbrennan970 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-11-2013, 06:50 AM
  7. Userform Multipage Event Change
    By sepandb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-31-2008, 01:40 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