VBA Forms multipage pages

Question

The help system doesn't explain if this is possible, i'd rather avoid using sendkeys.

On an Excel VBA user form i have a multipage control with 3 pages, Page1, Page2, Page3

On the Page1 tab I put a next button. I need code for the next buttons click event to navigate from page1 to page2

TIA

Answer 1

If you put the button outside the multipage control you can use the following to move next through all pages:

=======================================

With Me.MultiPage1

If .Value + 1 < .Pages.Count Then .Value = .Value + 1

End With

========================================

To move backwards put another button OUTSIDE the Multipage control and add the follwoing code:

=======================================

With Me.MultiPage1

If .Value + 1 > 1 Then .Value = .Value - 1

End With

=======================================