Hi all
I'd appreciate if anyone would be able to help me.
I have a user form with a multipage control [6 pages]. Page 4 contains a nested multipage consisting of two additional pages.
I have already created command buttons on the first 2 pages of the user form to jump to the next page using the code below:
My problem is that on page 3 my command button needs to be able to jump next page - in this case being page 1 or 2 [using if function] of the nested multipage2.
I have tried to work this out myself but I cannot seem to manage?
I'd appreciate if anyone would be able to help me.
I have a user form with a multipage control [6 pages]. Page 4 contains a nested multipage consisting of two additional pages.
I have already created command buttons on the first 2 pages of the user form to jump to the next page using the code below:
VBA Code:
Dim NextPage1 As Long
NextPage1 = UserForm1.MultiPage1.SelectedItem.Index + 1
UserForm1.MultiPage1.Value = NextPage1
My problem is that on page 3 my command button needs to be able to jump next page - in this case being page 1 or 2 [using if function] of the nested multipage2.
I have tried to work this out myself but I cannot seem to manage?