VBA Chart Project - Loop Through All Charts in a Workbook (Code Included) скачать в хорошем качестве

VBA Chart Project - Loop Through All Charts in a Workbook (Code Included)

This video is number five in our color chart project. In this video, we loop through every single sheet in a workbook, and we loop through every single chart. To do this, we declare a worksheet object, and we also declare a chart object. Then we use a For Loop to loop through each sheet and each chart object. To make the code easier to understand, we add some select statements. Also, we use a message box (MSGBOX) as we loop through the charts to show what chart is active. We also show you how to change the name of a Chart in the upper left by the formula bar. This video is perfect for someone looking at how to go through every sheet and every chart, and in the future videos, we will be showing how we put all of this together so that you can easily color a chart based on a cell color. ========================== 'CODE ========================== Sub ScratchSheetandChartO() Dim sht As Worksheet Dim cht As ChartObject For Each sht In Worksheets sht.Select For Each cht In sht.ChartObjects cht.Activate cht.Select MsgBox "Chart " & cht.Name & " is now active" Next Next End Sub