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.
Bookmarks