NamedRange.Speak(Object, Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assembly:: Microsoft.Office.Tools.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Causes the cells of the NamedRange control to be spoken in row order or column order.

public void Speak (object SpeakDirection, object SpeakFormulas);

abstract member Speak : obj * obj -> unit

Public Sub Speak (Optional SpeakDirection As Object, Optional SpeakFormulas As Object)

Parameters

SpeakDirection: Object

The speak direction, by rows or columns.

SpeakFormulas: Object

true will cause formulas to be sent to the Text-To-Speech (TTS) engine for cells that have formulas. The value is sent if the cells do not have formulas; false (default) will cause values to always be sent to the TTS engine.

Examples

The following code sample demonstrates how to use the Speak method to speak the contents of a NamedRange control named NamedRange1 by columns.

This example is for a document-level customization.

private void SpeakNamedRange()
{
    Microsoft.Office.Tools.Excel.NamedRange namedRange1 =
        this.Controls.AddNamedRange(this.Range["A1", "A5"],
        "namedRange1");

    namedRange1.Value2 = 10;
    namedRange1.Speak(Excel.XlSpeakDirection.xlSpeakByColumns,
        false);
}

Private Sub SpeakNamedRange()
    Dim namedRange1 As Microsoft.Office.Tools.Excel.NamedRange _
        = Me.Controls.AddNamedRange(Me.Range("A1", "A5"), _
        "namedRange1")

    namedRange1.Value2 = 10
    namedRange1.Speak(Excel.XlSpeakDirection.xlSpeakByColumns, _
        False)
End Sub

Remarks

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

Applies to