VBA - Selection Object

The Selection object represents the current selection in a window or pane.
The current selection is either the area that is currently highlighted or if nothing is highlighted then it represents the insertion point.
There can only be one Selection object per window (or pane) and there is only ever one selection that is currently active.

Creating a Selection Object

You can use the Pane object from the active Window object to return the current selection at any time.
The Selection object can only be returned from either an Application, Pane and Window object.

Important Differences

The Range and Selection objects refer to a continuous area within a document.
The Range and Selection objects are very similar but have some important differences:
1) There can only be one Selection object per window (or pane), but there can be many range objects
2) The active selection is always highlighted, whereas the range object is not visible unless selected.
The Selection object shares a lot of the same properties and methods as the Range object.

Redefining a Selection Object

You can use the SetRange method to redefine an existing Selection object
The following example defines a selection object to the be equal to the current selection and then redefines it to refer to the current selection plus the next 10 characters.

Using the Selection Object

You should always check the Type of the Selection object to make sure that it is sensible.
It is possible for the user to select a vertical block of text that does not have to be represent contiguous text. This can be done by holding down the alt key and dragging with the mouse.

Default Property (Text)

The Text property is the default property for a Selection object.

Identifying a Selection Object

You can use the Type property to help return information about the current selection

You can use the Flags property to

You can use the Information property to

Selection.Paste

Selection.TypeText

Inserts the text at the beginning of the current selection.
The selection is turned into an insertion point at the end of the inserted text.
If Options.ReplaceSelection = True then the original selection will be replaced.

This behaves exactly the same as typing some text at the keyboard.

Selection.TypeParagraph

Insert a paragraph mark at the beginning of the current selection.
The selection is turned into an insertion point after the inserted paragraph mark.
If Options.ReplaceSelection = True then the original selection will be replaced.

This behaves exactly the same as pressing the Enter key.

Selection.TypeBackspace

Insert a paragraph mark at the beginning of the current selection.
If the selection is an insertion point, delete the character in front of the insertion point.
If something is currently selected then the selection is turned into an insertion point at the beginning of the current selection.
If Options.ReplaceSelection = True then the original selection will be replaced.

Selection.PasteAndFormat

Selection.PasteAndFormat(wdRecoveryType.wdPasteDefault)
This method pastes the selected table cells and formats them as specified

Pastes the table cells and formats them as specified

It doesn't matter what the Zoom percentage is, the image is automatically resized to fit the width of the page
This line will paste an Excel chart as a picture

Selection.PasteExcelTable

Selection.PasteFormat

This example inserts the Clipboard contents at the insertion point as unformatted text.

This example copies the first paragraph in the document and pastes it at the insertion point.

This example copies the selection and pastes it at the end of the document.

This example copies the selected text and pastes it into a new document as a hyperlink. The source document must first be saved for this example to work.

Selection.Extend

Turns extend mode on (sets the ExtendMode property to True), or if extend mode is already on, extends the Selection object to the next larger unit of text.
The progression of selected units of text is as follows: word, sentence, paragraph, section, entire document.

Character - The character through which the selection is extended. This argument is case sensitive and must evaluate to a String or an error occurs. Also, if the value of this argument is longer than a single character, the command is ignored.

This example collapses the current selection to an insertion point and then selects the current sentence.

Here is an example that accomplishes the same task without the Extend method.

This example makes the end of the selection active and extends the selection through the next instance of a capital "R".

Selection - ExtendMode

This property is True when the Extend mode is active.
This property can only be set during run time; attempts to set it in Immediate mode are ignored. The Extend arguments of the EndOf and StartOf methods are not affected by this property.

This example moves to the beginning of the paragraph and selects the paragraph plus the next two sentences.

This example collapses the current selection, turns on Extend mode, and selects the current sentence.

Expanding the current Selection

The easiest way to expand a range is to use either the MoveRight or MoveLeft methods.
The Extend argument can either be wdMove or wdExtend. The default is wdMove.

This method cannot be used with a Range.

You can also use the Expand method. This method returns the number of characters added to the range.

This example expands the selection to include the entire sentence.

Selection Object - Collapsing

Even when a selection is collapsed to an insertion point it is not empty.
The Text property of a collapsed Selection object will still return the character immediately to the right of the insertion point.
This character will also appear in the Characters collection of the Selection object.

Selection.HomeKey

Moves the Selection object to the beginning of the specified unit.

Unit -
Extend - The default is wdMove.
This method returns a value (Long) that indicates the number of characters the selection has actually moved.
If it returns zero (0) then the moved was unsuccessful.

Selection.EndKey

Moves the Selection object to the end of the specified unit.

Unit -
Extend - The default is wdMove.
This method returns a value (Long) that indicates the number of characters the selection has actually moved.
If it returns zero (0) then the moved was unsuccessful.

Selection.MoveUp

Moves the Selection object up and returns the number of units it has moved.
The current selection is collapsed to the end point before being moved up.
The wdWindow constant can also be used to move to the top of the current screen.
The wdScreen constant can also be used to move more than one screen.

Unit - The unit can be either wdLine, wdParagraph, wdWindow, wdScreen. The default value is wdLine.
Count - The number of units to move. The default is 1.
Extend - The default is wdMove.

Selection.MoveDown

Moves the Selection object down and returns the number of units it has moved.
The current selection is collapsed to the end point before being moved up.
The wdWindow constant can also be used to move to the top of the current screen.
The wdScreen constant can also be used to move more than one screen.

Unit - The unit can be either wdLine, wdParagraph, wdWindow, wdScreen. The default value is wdLine.
Count - The number of units to move. The default is 1.
Extend - The default is wdMove.

Selection.MoveLeft

Moves the Selection object to the left and returns the number of units it has moved.
The current Selection object is collapsed to the end point before being moved left.

Selection.MoveRight

Moves the Selection object to the right and returns the number of units it has moved.
The current Selection object is collapsed to the end point before being moved right.

Selection.

The following methods also exist for a Selection:
Move, MoveStart, MoveEnd, MoveUntil, MoveWhile, MoveStartUntil, MoveEndUntil, MoveStartWhile, MoveEndWhile

The following moves to the start of the current line.

The following moves to the end of the line

This following moves the selection up three lines.

The following moves the selection down two paragraphs.

The following moves to the end of the document.

The following example moves to the start of the document.

The following moves the Selection object two words to the left.

The following moves the start position backwards until a capital "I" is found.
When the movement is backwards, the Range is expanded.

The following moves the start position forwards until a "%" characters is found or for a maximum of ten 10.
When the movement is forwards, the Range is reduced.

Backspace

This example inserts the text "Solutions" (enclosed in quotation marks) before the selection and then collapses the selection.

This example inserts all the font names in the FontNames collection into a new document.

This example inserts text at the end of the selection and then collapses the selection to an insertion point.

Deleting text

Removes all character formatting (formatting applied either through character styles or manually applied formatting) from the selected text.

Removes character formatting (formatting that has been applied manually using the buttons on the Ribbon or through the dialog boxes) from the selected text.

Removes character formatting that has been applied through character styles from the selected text.

Removes text and paragraph formatting from a selection.

Removes all paragraph formatting (formatting applied either through paragraph styles or manually applied formatting) from the selected text.

Removes paragraph formatting that has been applied manually (using the buttons on the Ribbon or through the dialog boxes) from the selected text.

Removes paragraph formatting that has been applied through paragraph styles from the selected text.

Selection Object - Properties

Selection Object - Methods