Excel 2010 VBA - Next and Previous Buttons

[eemiller1997]

I have a three page Multi-Page Userform. Off the the Multi-Page, but within the UserForm are Next and Previous buttons coded as follows:

Private Sub ButtonPrevious_Click()
       
    Dim i As Long
    
    i = IntvwWorksheet.Value - 1
    
    If i >= 0 Then
        IntvwWorksheet.Value = i
        
        End If
        
End Sub

and

Private Sub ButtonNext_Click()
    Dim i As Long
    
    i = IntvwWorksheet.Value + 1
    
    If i < IntvwWorksheet.Pages.Count Then
    IntvwWorksheet.Value = i
    
    End If
    
End Sub

Neither of them are working. Any ideas? Thank you in advance for your help!

[Norie]

What are the next/previous buttons and the multipage called?

[eemiller1997]

ButtonNext and ButtonPrevious

[Norie]

The code should work then.

Try adding breakpoints (F9) to both subs.

Then run the userform and try the buttons.

What happens?

[eemiller1997]

That is new to me. Where should my curse be when I hit F9?

[Norie]

On the first line of code or even the sub header itself.

[Norie]

In the file you attached in a previous thread the multipage was called MultiPage1 and IntvwWorksheet was the name of the userform.

[eemiller1997]

Oh, you are right. The multi-page is called MultiPage1. However, the Next, Previous, Done and Print buttons are off of the multi-page and on the IntvwWorksheet.

What is a break point and what does it do? When I press F9 on the line that says 'Private Sub ButtonNext_Click ()' I get a red line with a red circle at the beginning. If I press F9 on the line for 'Dim i As Long' I get a message saying 'Breakpoint not allowed on this line'

[Norie]

Setting a break point will make code execution break on the line of code they are on.

It's a useful way to halt things so you can see what's happening, eg what value variables have

Also if you know where an error occurs you can set a breakpoint before that point and then step through
the code up to where the error happens and see what's going on.

You can't set a breakpoint on everything, and that includes declarations.

Back to the code.

When I run it as is I get the error Method or property not found and one of the lines with IntvwWorksheet.Value is highlighted.

If I change IntvwWorksheet to Multipage1 there are no errors and the code works.

[eemiller1997]

Never mind - I had to get rid of that breakpoint.

Thank you for your help once again!!!

[eemiller1997]

Hmmm, when I make that change, the previous button works fine, but the Next button doesn't. I get no code, it just closes down my userform.

[Norie]

Aye, you need to mind and clear the breakpoints when you're finished with them.

Forget to do that myself all the time.