Change Chart Axis Font Color with a Checkbox

Originally Posted by Sbarro79

Hi Jason

Sorry my bad, I didn't realize that you used a Form formant not Activex formant.

So, now try this:

Right click on your checkbox, choose "assign macro", then if you have something like Checkbox5_Click on the list select it, choose Edit and then paste this code:

ActiveSheet.ChartObjects("Chart5").Activate

With ActiveChart.Axes(xlValue).TickLabels.Font
    If .Color = RGB(166, 166, 166) Then
        .Color = RGB(0, 0, 0)
    Else
        .Color = RGB(166, 166, 166)
    End If
End With
    
   ActiveSheet.Range("A1").Select  'to deactivate chart

Hope this help you.

Thanks, I got that to work but have now run into a new problem. I also have an "All" checkbox, that when clicked either makes all other checkboxes true or false. If I use that then the font color on the chart doesn't change. I could add a similar macro to that checkbox but then it is only changing the font color based on what it is and not on whether or not the checkbox beside it is true or false. I think I might try switching the checkboxes to ActiveX and trying your other suggested code and see if that solves it.


EDIT: got the ActiveX checkboxes inserted but ran into a couple of aesthetics issues that I can't figure out. First one, if a checkbox does not have a caption it looks kind of blurred..can that be changed? Second, when there is a caption when the checkbox is clicked the caption looks like it is selected (dashed box goes around the caption), how do I make it so that does not happen?