Range.ShowCard method (Excel)
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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for