| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List Charts Macro
This sub creates a message box listing worksheet charts, by chart number. Can the code be modified to show the chart title after the chart name
Sub ListCharts( Dim Msg As Strin Dim ChtObj As ChartObjec Msg = "Worksheet: " & ActiveSheet.Name & vbCrL For Each ChtObj In ActiveSheet.ChartObject Msg = Msg & vbCrLf & ChtObj.Nam Nex MsgBox Ms End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charts using List Feature | Excel Discussion (Misc queries) | |||
| Is there a list of names for the various charts... | Charts and Charting in Excel | |||
| How do I set up charts with a drop-down list? | Excel Discussion (Misc queries) | |||
| Adding titels to charts from a list | Charts and Charting in Excel | |||
| List Charts in a Worksheet | Excel Programming | |||
![Phil Hageman[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
