Export (0) Print
Expand All

Shape.HasTable Property

Office 2007
Returns msoTrue if the shape represents a TableFrame object or msoFalse if the shape represents any other object type. Read-only.

Syntax

expression.HasTable

expression   A variable that represents a Shape object.

Remarks

The HasTable property value can be one of the MsoTriState constants declared in the Microsoft Office type library and shown in the following table.

ConstantDescription
msoFalse The shapes in the range do not represent a TableFrame object.
msoTriStateMixedIndicates a combination of msoTrue and msoFalse for the specified shape range.
msoTrueThe shapes in the range represent a TableFrame object.

Example

This example checks the currently selected shape to see if it is a table. If it is, the code sets the width of column one to one inch (72 points).

Visual Basic for Applications
Sub IsTable()

    With Application.Selection.ShapeRange
        If .HasTable = msoTrue Then
            .Table.Columns(1).Width = 72
        End If
    End With

End Sub

See Also


Community Additions

ADD
Show:
© 2014 Microsoft