Edit

Share via

Range.ShowCard method (Excel)

  • Article

For a cell containing a Linked data type, such as Stocks or Geography, this method causes a card to appear that shows details about the cell (that is, the same card that the user can view by choosing the cell icon).

Syntax

expression.ShowCard

expression A variable that represents a Range object.

Remarks

For ranges of more than one cell, this method only attempts to show the card for the upper-left cell in the range. If that cell does not contain a Linked data type, nothing happens.

Example

This code shows the card for the Linked data type in cell E5.

Range("E5").ShowCard

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.