List Of Vba Else If 使い方 Article

201 公共方法 06 利用for else搜索字典列表 for else YouTube from www.youtube.com

Introduction

Visual Basic for Applications (VBA) is a powerful programming language used in Microsoft Excel. It allows users to automate tasks and create custom functions. One of the most useful VBA statements is the Else If statement. In this article, we will explore how to use the Else If statement in VBA.

What is the Else If Statement?

The Else If statement is used to check multiple conditions in a VBA program. It allows the program to execute a different set of statements depending on the result of the condition. The syntax for the Else If statement is as follows:

If condition1 Then 'statements ElseIf condition2 Then 'statements ElseIf condition3 Then 'statements Else 'statements End If

Using the Else If Statement

Let's say we want to create a VBA program that calculates the grade of a student based on their score. We can use the Else If statement to check the score and assign a grade accordingly. Here's an example:

Sub CalculateGrade() Dim score As Integer Dim grade As String score = InputBox("Enter the score:") If score >= 90 Then grade ="A" ElseIf score >= 80 Then grade ="B" ElseIf score >= 70 Then grade ="C" ElseIf score >= 60 Then grade ="D" Else grade ="F" End If MsgBox "The grade is " & grade End Sub

In this program, we first declare two variables: score and grade. We then use the InputBox function to prompt the user to enter the score. We use the If statement to check the score and assign a grade using the Else If statement. Finally, we display the grade using the MsgBox function.

Nesting Else If Statements

You can also nest Else If statements inside each other. This is useful when you need to check multiple conditions in a program. Here's an example:

Sub CheckNumbers() Dim num1 As Integer Dim num2 As Integer num1 = InputBox("Enter the first number:") num2 = InputBox("Enter the second number:") If num1 > num2 Then MsgBox "The first number is greater" ElseIf num1 < num2 Then MsgBox "The second number is greater" Else If num1 = num2 Then MsgBox "The numbers are equal" End If End If End Sub

In this program, we first prompt the user to enter two numbers using the InputBox function. We then use the If statement and Else If statement to check which number is greater. We then nest an additional If statement inside the Else statement to check if the numbers are equal.

Conclusion

The Else If statement is a powerful tool in VBA programming. It allows you to check multiple conditions and execute different sets of statements depending on the result. By mastering the Else If statement, you can create more complex and efficient VBA programs.