VBA 使用字符串参数评估函数

使用字符串参数评估函数的VBA方法是一种强大的技术，可以根据字符串中的函数名称和参数来执行相应的操作。这种方法可以在编写VBA代码时提供更大的灵活性和可扩展性。在本文中，我们将介绍如何使用字符串参数评估函数，并提供一个案例代码来说明其用法。

vba
Function Calculate(operation As String) As Double
    Dim result As Double
    
    Select Case operation
        Case "addition"
            result = 1 + 2
        Case "subtraction"
            result = 5 - 3
        Case "multiplication"
            result = 2 * 4
        Case "division"
            result = 10 / 2
        Case Else
            result = 0
    End Select
    
    Calculate = result
End Function

vba
Sub Example()
    Dim operation As String
    Dim result As Double
    
    operation = "addition"
    result = Calculate(operation)
    MsgBox "Result of " & operation & " is: " & result
    
    operation = "subtraction"
    result = Calculate(operation)
    MsgBox "Result of " & operation & " is: " & result
    
    operation = "multiplication"
    result = Calculate(operation)
    MsgBox "Result of " & operation & " is: " & result
    
    operation = "division"
    result = Calculate(operation)
    MsgBox "Result of " & operation & " is: " & result
    
    operation = "invalid"
    result = Calculate(operation)
    MsgBox "Result of " & operation & " is: " & result
End Sub