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 65535.

Error codes:

5 Invalid procedure call

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!