Thread
:
Code mod to add name
View Single Post
#
2
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
Code mod to add name
Phil,
Try
msg = msg & vbCrLf & chtob.Name & " " & chtob.Chart.ChartTitle.Caption
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Phil Hageman" wrote in message
...
This code puts a neat box on screen with the name of the
worksheet and a list of the charts - by name:
Sub ListCharts()
Dim msg As String
Dim chtob As ChartObject
msg = ActiveSheet.Name & vbCrLf
For Each chtob In ActiveSheet.ChartObjects
msg = msg & vbCrLf & chtob.Name
Next
MsgBox msg
End Sub
What modification would put the chart title after the
chart name?
Thanks,Phil
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson