Skip to Main Content
Writing Excel Macros with VBA, 2nd Edition
book

Writing Excel Macros with VBA, 2nd Edition

by Steven Roman PhD
June 2002
Beginner content levelBeginner
570 pages
16h 48m
English
O'Reilly Media, Inc.
Content preview from Writing Excel Macros with VBA, 2nd Edition

Name

SmartTag Related Objects

Synopsis

Path: Application  --  Range  --  SmartTags - SmartTag  -- SmartTagActions  --  SmartTagAction; 
Path: Application  --  Workbook  --  SmartTagOptions; 
Path: Application  --  SmartTagRecognizers - SmartTagRecognizer

Object

Methods

Properties

SmartTag

  • Delete( )

  • DownloadURL( ) As String

  • Name( ) As String

  • Properties( ) As CustomProperties

  • Range( ) As Range

  • SmartTagActions( ) As SmartTagActions

  • XML( ) As String

SmartTags

  • Add(SmartTagType As String) As SmartTag

  • Count( ) As Long

SmartTagAction

  • Execute( )

  • Name( ) As String

SmartTagActions

  • Count( ) As Long

  • Item(Index As Variant) As SmartTagAction

SmartTagOptions

  • DisplaySmartTags( ) As XlSmartTagDisplayMode

  • EmbedSmartTags( ) As Boolean

SmartTagRecognizer

  • Enabled( ) As Boolean

  • FullName( ) As String

  • progID( ) As String

SmartTagRecognizers

  • Count( ) As Long

  • Item(Index As Variant) As SmartTagRecognizer

  • Recognize( ) As Boolean

This collection of objects enables programmatic control over existing Smart Tags. Note that in order to create custom Smart Tags, we need need to use an application that can create COM DLLs, such as Visual Basic or Visual C++. Custom Smart Tags cannot be created in Excel XP. For more on Smart Tags, please see Chapter 22.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft Excel 2019 VBA and Macros, First Edition

Microsoft Excel 2019 VBA and Macros, First Edition

Bill Jelen, Tracy Syrstad
VBA and Macros for Microsoft Excel

VBA and Macros for Microsoft Excel

Bill Jelen, Tracy Syrstad
Excel 2016 VBA and Macros

Excel 2016 VBA and Macros

Bill Jelen, Tracy Syrstad

Publisher Resources

ISBN: 0596003595Supplemental ContentErrata Page