Excel VBA - 为什么包含数字的分割字符串的算术比较有效

VBA
Sub CompareNumericStrings()
    Dim str1 As String
    Dim str2 As String
    Dim num1 As Double
    Dim num2 As Double
    
    ' 设置字符串
    str1 = "ABC123"
    str2 = "ABC456"
    
    ' 分割字符串并转换为数值类型
    num1 = CDbl(Replace(str1, "ABC", ""))
    num2 = CDbl(Replace(str2, "ABC", ""))
    
    ' 比较数值
    If num1 < num2 Then</p>        MsgBox "str1 < str2"</p>    ElseIf num1 > num2 Then
        MsgBox "str1 > str2"
    Else
        MsgBox "str1 = str2"
    End If
End Sub