Home > VBAUsefulCodes
Change colour of the Shapes using VBA. It uses RGB format to specify the colour codes
Change colour of the Shapes
Change colour of the Shapes using VBA. It uses RGB format to specify the colour codes
Thisworkbook.Sheets("sheetname").Shapes("shape1").TextFrame.Characters.Font.ColorIndex = 1
Thisworkbook.Sheets("sheetname").Shapes("shape1").Fill.ForeColor.RGB = RGB(255, 255, 255)
Subscribe
More to Explore
Tags
VBA Outlook KPI Excel Alt+F11 Dashboards Macros Recording Graphs Automation Developer WaterFall Powerpoint Charts Pivot Tables Forecast Charts