VBA字符串插值语法

什么是VBA字符串插值语法？它存在吗？

我想使用Excel VBA格式化字符串.我有一个变量foo,我想把它放在一个范围的字符串中.

Dim row as Long
row = 1

myString = "$row:$row"

我想将字符串中的$行插值为"1"

您还可以构建自定义Format函数.

Public Function Format(ParamArray arr() As Variant) As String

    Dim i As Long
    Dim temp As String

    temp = CStr(arr(0))
    For i = 1 To UBound(arr)
        temp = Replace(temp, "{" & i - 1 & "}", CStr(arr(i)))
    Next

    Format = temp
End Function

Public Sub Test()

    Dim s As String

    s = "Hello"
    Debug.Print Format("{0}, {1}!", s, "World")
End Sub

Dim row as Long
Dim s as String

row = 1
s = "$" & row & ":$" & row