Excel Smart Tags Sample

Note

This sample runs only in Microsoft Office Excel 2007.

This sample demonstrates how you can incorporate smart tags into your Microsoft Office Excel solution. For more information about smart tags in Excel, see Smart Tags Overview.

This sample contains two smart tags. The first smart tag uses term-based recognition to convert airport codes to airport names. The second smart tag uses regular expressions to recognize and convert temperatures between Celsius and Fahrenheit.

Security noteSecurity Note:

This sample code is intended to illustrate a concept, and it shows only the code that is relevant to that concept. It may not meet the security requirements for a specific environment, and it should not be used exactly as shown. We recommend that you add security and error-handling code to make your projects more secure and robust. Microsoft provides this sample code "AS IS" with no warranties.

To run this sample

  1. Press F5.

  2. Move the pointer over text that is underlined, click the smart tag icon, and then click an action in the shortcut menu.

  3. Type a temperature in the Enter temperature to convert box and then press ENTER.

Demonstrates

  • How to add a smart tag to a document.

  • How to recognize string literals in a smart tag.

  • How to recognize regular expressions in a smart tag.

  • How to implement actions for a smart tag.

  • How to change the action menu item based on the recognized text.

See Also

Tasks

How to: Add Smart Tags to Excel Workbooks

Other Resources

Document-Level Samples