Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Visibility of Charts Through Checkbox Selection
Hi,
I'm trying to base the visibility of a chart off of whether a specific checkbox is selected or not. What should I be doing differently in my code? Sub ChangeChartVisibility() Dim tc As Object, cb As Object Set tc = Application.ActiveSheet.ChartObjects("Chart 3") Set cb = Application.ActiveSheet.MsForms.CheckBox("VolumeIn dicators") If cb.Enabled = True Then tc.Visible = True Else If cb.Enabled = False Then tc.Visible = False End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
selection and visibility, lost charts | Charts and Charting in Excel | |||
Dynamic data selection for charts | Charts and Charting in Excel | |||
Allow selection of only 1 checkbox | Excel Discussion (Misc queries) | |||
CheckBox Selection | Excel Programming | |||
Dynamic color selection in charts | Excel Programming |