XmlMappedRange.VerticalAlignment Property

Gets or sets the vertical alignment of the XmlMappedRange control.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
Property VerticalAlignment As Object

Object VerticalAlignment { get; set; }

Property Value

Type: System.Object
The vertical alignment of the XmlMappedRange control.

Remarks

The returned vertical alignment can be one of the following values:

• xlBottom

• xlCenter

• xlDistributed

• xlJustify

• xlTop

Examples

The following code example uses the HorizontalAlignment and VerticalAlignment properties to align the contents of XmlMappedRange to the bottom right. This code example assumes that the current worksheet contains an XmlMappedRange named CustomerLastNameCell.

Private Sub AlignBottomRight()
    Me.CustomerLastNameCell.HorizontalAlignment = _
        Excel.XlHAlign.xlHAlignRight
    Me.CustomerLastNameCell.VerticalAlignment = _
        Excel.XlVAlign.xlVAlignBottom
    Me.CustomerLastNameCell.Value2 = "The contents " & _
        "of this cell are aligned to the bottom right." 
    Me.CustomerLastNameCell.RowHeight = 100
    Me.CustomerLastNameCell.ColumnWidth = 75
End Sub

private void AlignBottomRight()
{
    this.CustomerLastNameCell.HorizontalAlignment = 
        Excel.XlHAlign.xlHAlignRight;
    this.CustomerLastNameCell.VerticalAlignment =
        Excel.XlVAlign.xlVAlignBottom;

    this.CustomerLastNameCell.Value2 = "The contents " +
        "of this cell are aligned to the bottom right.";
    this.CustomerLastNameCell.RowHeight = 100;
    this.CustomerLastNameCell.ColumnWidth = 75;
}

.NET Framework Security

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

See Also

Reference

XmlMappedRange Interface

Microsoft.Office.Tools.Excel Namespace