ExcelMadeEasy: VBA select case in Excel

Vba Select Case in Excel

The "Select Case" statement is another logical function of Excel used to perform conditional execution of code. VBA CASE SELECT function in Excel is very useful when having a lot of different choices and having to branch from them. The advantage of SELECT CASE over IF THEN is that it is much more easy to read and implement.

This "Select" part defines the variable to be checked and the "Case" part defines the conditions

Syntax

Select Case <expression>

Case <condition1>
do result1
Case <condition2>
do result2

End Select

The Select Case statement can check for any number of conditions

Example: The following example selects a string variable and perform conditional execution of code

Sub SelectCase()
Dim str As String
str = "Hello"
Select Case str
Case "Hello"
MsgBox "Condition is True"
Case "World"
MsgBox "Condition is False"
End Select
End Sub

The important thing is, the statement executes until a true condition is met and the remaining conditions are ignored.

excel vba select case

The Result is as shown below

excel vba select case

You can find similar Excel Questions and Answer hereunder

1) Is there any way I can see more region of my WorkSheet?

2) I have read that Merging cells should be avoided if possible. In Excel, how can I then make my Title appear in the center of my Data Table?

3) Here some explanations about xml and how to use xml in VBA

4) I have several pictures that are misaligned - manually aligning them is very laborious. Is there an automatic alignment option?

5) How can I get users to select a file for processing using my macro?

6) I have to enter non alphanumeric characters in a cell using VBA - how can I get their codes for use in VBA?

7) How to get user input in VBA with the inputbox function

8) I have 2 sets of lists from 2 different reports - how can I select the cells with differences?

9) Can I add a small chart to Table data to make it visually appealing and easy to interpret?

10) How to hide and unhide rows and columns in excel VBA

Here the previous and next chapter