VBA Case Question

[Pinaceous]

Hi All,

How do I write in code the following verbal:

If opens on Sheet(1) or Sheet(8) then Call MySubA.

If opens on Sheet(10) then Call MySubB

Many thanks in advance!

R/
Pinaceous

 

[My Aswer Is This]

Your wanting to run script named "MySubA" any time you activate Sheet (1) or Sheet(8) is that what you want?

And any time Sheet (10).activated you want to run script named "MySubB"

 

[Pinaceous]

Yes, that is correct.

The workbook should only be opened to one of these sheets, where I want an independent Sub to be run for each sheet when opened, respectfully.

Thank you!

 

[My Aswer Is This]

Are you wanting the script to run any time the "Workbook" is Opened or any time a Worksheet is activated?

And if when "Workbook" is opened then what worksheet do you want to be activated when the Workbook is opened.

Please give more details.

 

[Fluff]

Is this the sort of thing you're after

    Select Case ActiveSheet.Index
        Case 1, 8
            Call MySubA
        Case 10
            Call MySubB
    End Select

 

[Pinaceous]

Hi Fluff,

Yes, that is what I'm looking for.

Thanks very much!

Respectively,
Pinaceous

 

[Fluff]

Glad to help & thanks for the feedback