select case

[ccordner]

Hi

I found a trick here to link to a chart worksheet in excel. I have modified it as below:

 Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Select Case Target.TextToDisplay
    Case "NPS Overall satisfaction TTW"
    
        Sheets("NPS by PMU").Select
    Case "NPS Overall satisfaction WNY"
    
        Sheets("NPS by PMU").Select
    Case "NPS Overall satisfaction SEY"

But there are about forty charts and fifty or so links - a few link to the same chart. Is there any way of doing something like this:

 Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Select Case Target.TextToDisplay
    Case "NPS Overall satisfaction TTW" or "NPS Overall satisfaction WNY"
    
        Sheets("NPS by PMU").Select

    Case "NPS Overall satisfaction SEY"

Chris

 

[Jonmo1]

Replace the word "or" with a comma

 

[VoG]

Try

Select Case Target.TextToDisplay
    Case "NPS Overall satisfaction TTW", "NPS Overall satisfaction WNY"

 

[ccordner]

That's great, thanks!