ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Identify Smart Tag (https://www.excelbanter.com/excel-programming/416792-identify-smart-tag.html)

ExcelMonkey

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


All times are GMT +1. The time now is 03:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com