AlternativeText Property of Shapes

All shapes (including Charts) in Excel have AlternativeText property. This property can be used to store some information as well. Following is the code to read and write to AlternativeText property of a shape.
Sub SetAlternativeText() Sheet1.Shapes("Rectangle 1").AlternativeText = "ABC" End Sub Sub GetAlternativeText() MsgBox Sheet1.Shapes("Rectangle 1").AlternativeText End Sub
»
- Vishesh's blog
- Add new comment
- 1455 reads

Recent comments
4 hours 59 min ago
8 hours 23 min ago
8 hours 46 min ago
14 hours 48 min ago
15 hours 40 min ago
1 day 6 hours ago
1 day 6 hours ago
1 day 9 hours ago
1 day 17 hours ago
2 days 13 hours ago