VB 与 VBA 有什么区别

VB（Visual Basic）和VBA（Visual Basic for Applications）是两种编程语言，它们都是基于Basic语言的，用于开发应用程序和自动化任务。尽管它们有一些共同之处，但也存在一些关键区别。本文将探讨VB和VBA之间的区别，并通过案例代码来说明它们的应用场景。

vb
Public Class Calculator
    Private Sub btnCalculate_Click(sender As Object, e As EventArgs) Handles btnCalculate.Click
        Dim num1 As Integer = Integer.Parse(txtNum1.Text)
        Dim num2 As Integer = Integer.Parse(txtNum2.Text)
        Dim sum As Integer = num1 + num2
        lblResult.Text = "结果：" & sum.ToString()
    End Sub
End Class

vba
Sub GenerateRandomNumbers()
    Dim rng As Range
    Set rng = Range("A1:A10")
    
    Dim cell As Range
    For Each cell In rng
        cell.Value = Int((100 - 1 + 1) * Rnd + 1)
    Next cell
End Sub