Getting started with VBA Declaring Variables Scripting.FileSystemObject Procedure Calls Naming Conventions Creating a procedure Flow control structures Comments Arrays Error Handling Recursion Conditional Compilation Data Types and Limits String Literals - Escaping, non-printable characters and line-continuations Declaring and assigning strings Converting other types to strings Searching within strings for the presence of substrings Substrings Measuring the length of strings Working with ADO Concatenating strings Assigning strings with repeated characters Scripting.Dictionary object VBA Option Keyword Date Time Manipulation Creating a Custom Class Events Attributes User Forms Object-Oriented VBA Working With Files and Directories Without Using FileSystemObject Operators Collections Passing Arguments ByRef or ByVal CreateObject vs. GetObject Macro security and signing of VBA-projects/-modules Data Structures Interfaces Reading 2GB+ files in binary in VBA and File Hashes Sorting Frequently used string manipulation Automation or Using other applications Libraries VBA Run-Time Errors Copying, returning and passing arrays Non-Latin Characters API Calls

Assigning strings with repeated characters

Remarks:

There are times you need to assign a string variable with a specific character repeated a specific number of times. VBA provides two main functions for this purpose:

String/String$
Space/Space$.

Use the String function to assign a string with n repeated characters

Dim lineOfHyphens As String
'Assign a string with 80 repeated hyphens
lineOfHyphens = String$(80, "-")

Use the String and Space functions to assign an n-character string

Dim stringOfSpaces As String

'Assign a string with 255 repeated spaces using Space$
stringOfSpaces = Space$(255)

'Assign a string with 255 repeated spaces using String$
stringOfSpaces = String$(255, " ")

Contributors

Topic Id: 3581

Example Ids: 12359,12360

This site is not affiliated with any of the contributors.