Last Updated on January 11, 2023 by token
1. Space VBA function – Description
The Space VBA function returns the number of spaces specified in the argument. So, if we want to get a text with only 100 spaces, enter the number 100 in the argument.
2. VBA Space function – Syntax
Space (integer)
Integer – The number of spaces we want to return with the function.
Function return : String / text value.
3. VBA Space function – Example
How to use the Space function in VBA Excel? Below is an example of using the Space function in the VisualBasic Editor.
Sub SpaceFunctionExample ()
MsgBox Space (10)
MsgBox "text" & Space (20) & "text"
Range ("A1") = "text" & Space (20) & "text"
MsgBox Range ("A1") & Space (10) & "text"
End Sub
4. Space VisualBasic function – Where to use?
The function can be used in: Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Excel 365.
The article is part of the VBA Excel function list. You can find a list of all VBA functions at this address: VBA functions.
