Smart Tags

SmartTags provided a way to recognise values that have specific signatures.
When this item is found a small tag is displayed that contains a popup menu.


AutoCorrect

For more details about this smart tag, please refer to the AutoCorrect Smart Tag page.


Paste

For more details about this smart tag, please refer to the Paste Smart Tag page.


Auto Fill

For more details about this smart tag, please refer to the Auto Fill Smart Tag page.


Insert

For more details about this smart tag, please refer to the Insert Smart Tag page.


Error Checking

For more details about this smart tag, please refer to the Error Checking Smart Tag page.


Flash Fill

For more details about this smart tag, please refer to the Flash Fill Smart Tag page.


Quick Analysis

For more details about this smart tag, please refer to the Quick Analysis Smart Tag page.


Apply Formatting Rule To Smart Tag

Pivot Tables - Apply Formatting Rule


Date (XML) Smart Tag

Enter "02/10/2014"
right mouse click


Finance Symbols Smart Tag

Removed in Excel 2010.
(Office > Excel Options)(Proofing tab, AutoCorrect Options)
Smart Tags tab
Tick "Label data with smart tags"
Select "Financial Symbol"
You can even save the smart tag with the actual workbook.


Type "MSFT" into a cell
A small purple indicator appears in the bottom right corner
SS


Financial Symbol -
Insert Refreshtable stock price -
Stock Quote -
Company Report -
Recent News -
Remove this Smart Tag -
Stop Recognising -
Smart Tag Options -


Person Name Smart Tag

Removed in Excel 2010.

Application.SmartTagRecognizers 


The Range has a SmartTags property that returns a collection of all the SmartTag objects.


Name Property

This is the fully qualified name of the smart tag consisting of an XML namespace URL followed by a number sign (#) and then a tag name
For example

urn:schemas-microsoft-com:office:smarttags#stockticker 


Do not confuse the Name with the Text


The DownloadURL property is an optional URL that is specified by the smart tag creator
It provides an additional address where additional tags can be downloaded.


© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

Top

PrevNext