Don't run script when active page is clicked

[kelly mort]

If the active page is page3 or page5, then don't say hello when it's clicked.

It's giving me a headache. Can someone fix that for me?

Private Sub MultiPage1_Click (ByVal Index As Long )
With MultiPage1
Select Case .Value 
    Case 2, 4 : MsgBox "Hello"
End Select 
End With
End Sub

 

[My Aswer Is This]

Just so you know:

Your first page is considered 0
Your second page is considered 1


So in your case you need at least 5 pages

 

[My Aswer Is This]

So in your case your script should look like this:

Private Sub MultiPage1_Click(ByVal Index As Long)
'Modified  1/20/2019  7:36:16 AM  EST
With MultiPage1
    Select Case .Value
        Case 0, 1, 3: MsgBox "Hello"
    End Select
End With
End Sub

 

[kelly mort]

Yeah I am aware of that .

Case 2 represents my third page
Case 4 represents my fifth page


So currently when I click on the page 3 or page 5 it says hello.

However, I want to stop the script from running when page 3 is active and I click it again.

Or when page 5 is active and I click it again.

Regards

 

[My Aswer Is This]

That's a hard one for me.
This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.

 

[kelly mort]

That's a hard one for me.
This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.

Okay thanks.

 

[John_w]

Use the event's Index parameter:

        Select Case Index

 

[kelly mort]

Use the event's Index parameter:

        Select Case Index

How do I fix that into my code?

I will be glad if you can show me that way.

Regards

 

[John_w]

As shown in my code, use Index instead of .Value in the Select Case

Private Sub MultiPage1_Click(ByVal Index As Long)
    With MultiPage1
        Select Case Index
            Case 2, 4
                'Do nothing for tabs 3 and 5
            Case Else
                MsgBox "Hello", Title:="Index = " & Index
        End Select
    End With
End Sub

 

[kelly mort]

Yeah I am aware of that .

Case 2 represents my third page
Case 4 represents my fifth page


So currently when I click on the page 3 or page 5 it says hello.

However, I want to stop the script from running when page 3 is active and I click it again.

Or when page 5 is active and I click it again.

Regards

The script is not doing my request over here. Is there a way to achieve this?