TextFrame.Characters method (Excel)

Returns a Characters object that represents a range of characters within a shape's text frame. Use the Characters object to add and format characters within the text frame.

Syntax

expression.Characters (Start, Length)

expression An expression that returns a TextFrame object.

Parameters

Name	Required/Optional	Data type	Description
Start	Optional	Variant	The first character to be returned. If this argument is either set to 1 or omitted, the Characters method returns a range of characters starting with the first character.
Length	Optional	Variant	The number of characters to be returned. If this argument is omitted, the Characters method returns the remainder of the string (everything after the character that was set as the Start argument).

Return value

Characters

Remarks

The Characters object isn't a collection.

Example

This example formats as bold the third character in the first shape's text frame on the active worksheet.

With ActiveSheet.Shapes(1).TextFrame 
 .Characters.Text = "abcdefg" 
 .Characters(3, 1).Font.Bold = True 
End With

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.