<div>
I mean not INSIDE of a Case, but execute a few Case statements in a row, if conditions are satisfied, i.e. perform Case a AND Case b<br />
<br />
is it possible somehow?
</div>


I mean not INSIDE of a Case, but execute a few Case statements in a row, if conditions are satisfied, i.e. perform Case a AND Case b

is it possible somehow?

<div>
you mean:<br />

<pre><code id="code-355864">Select Case true
     Case a OR c OR d
     'do something
     Case b 
     'do something
End select
</code></pre>
</div>


you mean:


Select Case true
     Case a OR c OR d
     'do something
     Case b 
     'do something
End select


<div>
Yes, if both the conditions are true, ex a = true and b = true, it will only execute the first, i.e. a=true condition and exit. Case b will not be checked and executed<br />
<br />
what I need is to execute ALL individual Case statement, if the conditions are satisfied.
</div>


Yes, if both the conditions are true, ex a = true and b = true, it will only execute the first, i.e. a=true condition and exit. Case b will not be checked and executed

what I need is to execute ALL individual Case statement, if the conditions are satisfied.

<div>
<div class="content wysiwyg-content">
Hi x-perts,<br />
<br />
Is there a way to write a Select Case statement with a FEW executable Case options, i.e. when a=true and b = true?<br />
<br />
of course, I can write all IF statements, but it would be much easier with Select Case <br />
<br />
Thanks<br />

<pre><code id="code-355839">Select Case true
     Case a
     'do something
     Case b 
     'do something
End select
</code></pre>
</div>
</div>


Hi x-perts,

Is there a way to write a Select Case statement with a FEW executable Case options, i.e. when a=true and b = true?

of course, I can write all IF statements, but it would be much easier with Select Case 

Thanks

VBA &quot;Select Case&quot; multiple conditions

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VBA &quot;Select Case&quot; multiple conditions

VBA "Select Case" multiple conditions