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
- Login or register to post comments
- 10839 reads
Recent comments
6 years 10 weeks ago
6 years 48 weeks ago
7 years 8 weeks ago
7 years 11 weeks ago
7 years 12 weeks ago
7 years 17 weeks ago
7 years 25 weeks ago
7 years 26 weeks ago
7 years 26 weeks ago
7 years 26 weeks ago