Replaces a specified number of characters in a String variable with characters from another string.

Mid( _
   ByRef Target As String, _
   ByVal Start As Integer, _
   Optional ByVal Length As Integer _
) = StringExpression

Parts

Target

Required. Name of the String variable to modify.

Start

Required. Integer expression. Character position in Target where the replacement of text begins. Start uses a one based index.

Length

Optional. Integer expression. Number of characters to replace. If omitted, all of String is used.

StringExpression

Required. String expression that replaces part of Target.

Remarks

The number of characters replaced is always less than or equal to the number of characters in Target.

Example

This example uses the Mid statement to replace a specified number of characters in a string variable with characters from another string.

Dim MyString As String
MyString = "The dog jumps"   ' Initializes string.
Mid(MyString, 5, 3) = "fox"   ' MyString = "The fox jumps".
Mid(MyString, 5) = "cow"   ' MyString = "The cow jumps".
Mid(MyString, 5) = "cow jumped over"   ' MyString = "The cow jumpe".
Mid(MyString, 5, 3) = "duck"   ' MyString = "The duc jumpe".

See Also

Mid Function