Skip to main content

Range.ShowCard method

Table of contents
  1. Syntax
  2. Remarks
  3. Example

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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>