how to put a reference from a page of a multipage form to another page

  • Thread starter Thread starter Valeria
  • Start date Start date
V

Valeria

Dear experts,
I have a multipage form, and I would like to put a button
on page 6 that redirects the user to page 4.
How can I achieve this?
Many thanks in advance!
Best regards,
Valeria
 
Dear experts,
I have a multipage form, and I would like to put a button
on page 6 that redirects the user to page 4.
How can I achieve this?
Click to expand...

If I understand you correctly, you can do this:

- Put a command button on page 6.
- Double click on that button to open the code module, and that
command button's Click event.
- Put the following code in there. Change the control names to:
* The name of your user form; and
* The name of your multipage control. I've left the default names in
for illustration only.
DON'T change the value. It's 3 because the multipage index starts
counting from 0. (Page1 = 0, Page2 = 1 and so on.)

Private Sub CommandButton1_Click()

UserForm1.MultiPage1.Value = 3

End Sub
 
Back
Top