Microsoft Office Tutorials and References
In Depth Information
Table 4-11. Comparison Operators
Operator
Description
=
Determines if two values are equal
<
Determines if value on left side of operand is less than value on right side
>
Determines if value on left side of operand is greater than value on right side
<=€
Determines if value on left side of operand is less than or equal to value on
right side
>=
Determines if value on left side of operand is greater than or equal to value
on right side
<>
Determines if two values are not equal to each other
The following code fragments show examples of using the If…Then…Else statement to
determine if a person’s age allows them to vote:
If intAge >= 18 Then
boolAllowVote = True
Else
boolAllowVote = False
End If
If boolAllowVote Then
[Display ballot and record vote]
End If
intReturn = MsgBox("Do you wish to continue?", vbYesNo + vbExclamation, "My App")
If intReturn = vbYes Then
[Continue processing]
Else
[Exit Procedure]
End If
Select Case Statements
Select Case statements allow you to check for multiple values at once. Suppose you had to cal­
culate different values depending upon what month it was. You would need to write eleven
If…Then…Else statements to check for all twelve months, but using a Select Case statement
lets you drop the number of conditional statements to one, making your code easier to read
and maintain.
The syntax of the Select Case statement is shown here.
Select [Case] testcondition
[Case expressionlist
statements ] ] [
[Case Else
elsestatements
End Select
Search JabSto ::




Custom Search