str(1) 返回前面有一个空格 excel vba

在Excel VBA中，使用str(1)函数来返回一个前面有一个空格的字符串。这个函数可以在字符串的开头添加一个空格，非常方便。下面将介绍如何使用这个函数，并给出一些示例代码。

vba
str(number)

vba
Dim x As Integer
Dim result As String
x = 1
result = " " & str(x)
MsgBox result

vba
Dim length As Integer
Dim result As String
length = 10
result = str(length) & " cm"
MsgBox result

vba
Sub AddSpaceToString()
    Dim x As Integer
    Dim result As String
    x = 1
    result = " " & str(x)
    MsgBox result
End Sub
Sub AddUnitToString()
    Dim length As Integer
    Dim result As String
    length = 10
    result = str(length) & " cm"
    MsgBox result
End Sub