$ whois vba

VBA

first released in 1993 · by Microsoft

$ guessprog --inspect vba

year: 1993
paradigm: procedural
family: basic
memory: reference counting
binding: gradual
safety: weak

VBA(7)

AUTHORS: Microsoft
HISTORY: Visual Basic for Applications first shipped in 1993 inside Excel 5.0, replacing the cryptic macro languages of each Office program with a single dialect of Visual Basic. It runs inside its host application and drives it through COM objects such as workbooks, sheets and ranges. Variables can be declared with a type, or left as a Variant that accepts anything, and the language freely converts between strings and numbers.
USAGE: Possibly the most widely written language among people who are not professional programmers: finance, accounting and operations teams still run on Excel macros. Microsoft keeps it supported but steers new automation to Office Scripts and Python in Excel.
SEE ALSO: VBA on Wikipedia ↗

$ cat Module1.bas

Sub HighlightLateInvoices()
    Dim cell As Range
    Dim lateCount As Long

    For Each cell In Worksheets("Invoices").Range("D2:D200")
        If cell.Value <> "" And cell.Value < Date Then
            cell.Interior.Color = RGB(255, 200, 200)
            lateCount = lateCount + 1
        End If
    Next cell

    ' "&" joins, but "+" would also turn the number into text
    MsgBox lateCount & " late invoices", vbInformation
End Sub