VBA 属性调用 Get 而不是 Let

VBA是一种用于编程的语言，可以在Microsoft Office软件中进行自动化操作。在VBA中，我们经常使用属性来存储和访问对象的值。在使用属性时，我们可以选择使用Get或Let方法来设置或获取属性的值。本文将介绍为何在VBA中使用Get属性调用而不是Let属性调用，并提供一些案例代码来说明。

Private pScore As Integer
Public Property Get Score() As Integer
    ' 在获取成绩之前进行一些额外的操作
    ' 比如判断成绩是否合法
    If pScore < 0 Then
        Score = 0
    ElseIf pScore > 100 Then
        Score = 100
    Else
        Score = pScore
    End If
End Property
Public Property Let Score(value As Integer)
    pScore = value
End Property

Private pWidth As Double
Private pHeight As Double
Public Property Get Width() As Double
    Width = pWidth
End Property
Public Property Let Width(value As Double)
    pWidth = value
End Property
Public Property Get Height() As Double
    Height = pHeight
End Property
Public Property Let Height(value As Double)
    pHeight = value
End Property
Public Property Get Area() As Double
    Area = Width * Height
End Property