Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 553
Default Identify Smart Tag

I know that if I have a smart tag in cell C2 I can extract the parent name as
follows:

MsgBox (Worksheets("Sheet1").Range("C2").SmartTags.Parent )

How do I test if the cell in question is in fact a SmartTag. Can you use
the set stmt and Set a variable to a SmartTag Object and then test to see if
the SmartTagObject is Nothing?

The following does not work:
Set X = Worksheets("Sheet1").Range("D2").SmartTags
neither does:
Set X = Worksheets("Sheet1").Range("D2").SmartTags.Parent

Thanks

EM
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Invest smart Mr. Buck Excel Worksheet Functions 0 February 2nd 08 09:59 PM
Invest smart Mr. Buck Excel Discussion (Misc queries) 0 February 2nd 08 09:59 PM
Invest smart Mr. Buck Charts and Charting in Excel 0 February 1st 08 04:09 AM
smart doc rahul[_2_] Excel Programming 0 September 6th 07 03:47 PM
smart charts Dave Breitenbach Charts and Charting in Excel 2 June 27th 05 02:15 AM


All times are GMT +1. The time now is 02:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"