SelLength Property

Applies To

ComboBox control, TextBox control.

Description

The number of characters selected in a text box or the text portion of a combo box.

Syntax

object.SelLength [= Long]

The SelLength property syntax has these parts:

Part	Description

object	Required. A valid object.
Long	Optional. A numeric expression specifying the number of characters selected. For SelLength and SelStart, the valid range of settings is 0 to the total number of characters in the edit area of a ComboBox or TextBox.

Remarks

The SelLength property is always valid, even when the control does not have focus. Setting SelLength to a value less than zero creates an error. Attempting to set SelLength to a value greater than the number of characters available in a control results in a value equal to the number of characters in the control.

Note Changing the value of the SelStart property cancels any existing selection in the control, places an insertion point in the text, and sets SelLength to zero.

The default value, zero, means that no text is currently selected.

See Also

SelStart property, SelText property.

Example

The following example tracks the selection-related properties (SelLength, SelStart, and SelText) that change as the user moves the insertion point and extends the selection using the keyboard. This example also uses the Enabled and EnterFieldBehavior properties.

To use this example, copy this sample code to the Declarations portion of a form. Make sure that the form contains:

One large TextBox named TextBox1.

Three TextBox controls in a column named TextBox2 through TextBox4.

Private Sub TextBox1_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, _
        ByVal Shift As Integer)
    TextBox2.Text = TextBox1.SelStart
    TextBox3.Text = TextBox1.SelLength
    TextBox4.Text = TextBox1.SelText
End Sub

Private Sub UserForm_Initialize()
    TextBox1.MultiLine = True
    TextBox1.EnterFieldBehavior = fmEnterFieldBehaviorRecallSelection

    TextBox1.Text = "Type your text here. Use CTRL+ENTER to start a new line."
End Sub