UserForm doesn't provide such of functionality...
You can achieve that by:
1) adding Mulitpage control
Let's say Multipage control has 2 pages. You want to display only first one and the second only in case when user click on the button.
Set its Multipage's
Style
property to
fmTabStyleNone
to hide pages.
You can chance currently active page by setting
Multipage.Value
property.
0
is for first page,
1
for second, and so on. For example:
Private Sub CmdAdditionalData_Click()
Me.MultiPage1.Value = 1
End Sub
Private Sub CmdBack_Click()
Me.MultiPage1.Value = 0
End Sub
2) changing UserForm size
Let's say you have 2 sets of controls: obligatory and additional.
Obligatory controls have to be placed near of the left side of
UserForm
. Additional controls have to be placed on the right side of obligatory controls or down to them, because you can change the size of control only by growing its height or width. Arrange them in
Frame
s.
Initial size of
UserForm
have to be equal to the size of
Frame
which holds obligatory controls.
Try!
Good luck!