Space and Spc Functions

αžαŸ’αžšαž‘αž”αŸ‹β€‹αžαŸ’αžŸαŸ‚β€‹αž’αž€αŸ’αžŸαžšβ€‹αž˜αž½αž™ αžŠαŸ‚αž›β€‹αž˜αžΆαž“β€‹αž…αŸ†αž“αž½αž“β€‹αžŠαž€β€‹αžƒαŸ’αž›αžΆβ€‹αžŠαŸ‚αž›β€‹αž”αžΆαž“β€‹αž”αž‰αŸ’αž‡αžΆαž€αŸ‹β€‹β€‹Β αŸ”

note

The Spc function works the same as the Space function.


Syntax:

Space (n As Long)

Spc (n As Long)

Return value:

αžαŸ’αžŸαŸ‚β€‹αž’αž€αŸ’αžŸαžš

Parameters:

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

Error codes:

5 αž€αžΆαžšβ€‹αž αŸ…β€‹αž”αŸ‚αž”αž”αž‘β€‹αž˜αž·αž“β€‹αžαŸ’αžšαžΉαž˜αžαŸ’αžšαžΌαžœ

Example:


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,"Info:"
End Sub

Please support us!