Multiple Instruction within a Case statement

**ydrive** · 01-06-2017, 11:04 AM

How can I realize two or more instructions in a case statement?

For example:
Select case
Case1: Instruction 1; Instruction 2; Instruction 3
Case2: Instruction 4; Instruction 5
Case else: Something else
End select

**thinhvd** · 01-06-2017, 11:31 AM

Using And Function after Select case

**ydrive** · 01-06-2017, 01:06 PM

I may not understand this correctly but do you refer to Conditions for the "select case"?

Or do you mean "case 1: MsgBox("Text") AND variable1= 17 AND DoSomethingElse" ?

**shg** · 01-06-2017, 01:40 PM

Please Login or Register  to view this content.

**ydrive** · 01-06-2017, 01:54 PM

Thank you

I had to edit this post:

I did it exactly as you said, that means "just make a new line for every instruction within the CASE statement"

No ":" necessary, no "&" or "AND" necessary

I did not know it would be THAT EASY. Thanks again @shg

**shg** · 01-06-2017, 07:37 PM

You're welcome.

Multiple Instruction within a Case statement

LinkBack

Thread Tools

Rate This Thread

Display

Multiple Instruction within a Case statement

Re: Multiple Instruction within a Case statement

Re: Multiple Instruction within a Case statement

Re: Multiple Instruction within a Case statement

Re: Multiple Instruction within a Case statement

Re: Multiple Instruction within a Case statement

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] i have an if then statement that works, how to make it work as a with or case statement

[SOLVED] Case Statement with Multiple Conditions

[SOLVED] is if-then or select case statement with multiple arguments possible?

adjusting variable after each step of calculation,case select statement with multiple expr

Select case instead of if statement formula in multiple cells (macro)

[SOLVED] Utilize a Select Case Statement in Target Intersect Statement

Switch(case) statement(enhanced if statement)

Bookmarks

Bookmarks

Posting Permissions