Space and Spc Functions

Возвращает строку, которая состоит из указанного количества пробелов.

The Spc function works the same as the Space function.

Синтаксис:

Space (n As Long)

Spc (n As Long)

Return type:

String

Параметры:

n: Numeric expression that defines the number of spaces in the string. The maximum allowed value of n is 2,147,483,648.

Коды ошибок:

5 Неправильный вызов процедуры

Пример:


Sub ExampleSpace
Dim sText As String, sOut As String
Dim iLen As Integer
    iLen = 10
    sText = "Las Vegas"
    sOut = sText & Space(iLen) & sText & Chr(13) &_
    sText & Space(iLen*2) & sText & Chr(13) &_
    sText & Space(iLen*4) & sText & Chr(13)
    msgBox sOut,0,"Сведения:"
End Sub