Скачать или смотреть Session #3 - Using IF...ELSE Statements and TEXT Functions in VBA |

Using IF...ELSE Statements and TEXT Functions in VBA

Description:
In Microsoft Excel VBA (Visual Basic for Applications), the IF...ELSE statement is a powerful conditional control structure used to execute different blocks of code based on logical tests. It helps automate decision-making in macros and custom functions. The TEXT function in VBA is used to format numbers, dates, and strings according to specific patterns, allowing you to present data clearly in Excel. Combining If...Else logic with text formatting enhances your VBA scripts for better readability, flexibility, and professional reporting.

Example (IF...ELSE in VBA):

Sub CheckScore()
Dim score As Integer
score = 75

If score = 90 Then
MsgBox "Excellent"
ElseIf score = 60 Then
MsgBox "Pass"
Else
MsgBox "Fail"
End If
End Sub


Example (TEXT Function in VBA):

Sub FormatDate()
Dim myDate As Date
myDate = Date
MsgBox Format(myDate, "dddd, mmmm dd, yyyy")
End Sub


Explanation:

If...Else checks conditions and executes specific code blocks.

Format() (VBA equivalent of Excel’s TEXT function) converts numbers or dates into formatted text strings.

Together, they let you create dynamic, user-friendly Excel macros that adapt based on conditions and display data in a professional format.