Hi All, I'm making a dynamic chart with code I found online (peltiertech.com), it was a post from 2009 so I hope you can help:
Sub ClickSeriesCheckbox()
Dim rCell As Range
For Each rCell In ActiveSheet.Range("TrueFalseRange").Cells
rCell.EntireColumn.Hidden = Not rCell.Value
Next
End Sub
This is causing my sheet to run very slowly. Is there something I can do to make it run faster?
I want to make a chart that changes according to the variables people select with the form control checkboxes. I'm using this code to hide the columns that are not being used, it is around 20 columns total and it takes about 10-15 sec each time I check/uncheck a box.
What would you do?
Thanks!
Sub ClickSeriesCheckbox()
Dim rCell As Range
For Each rCell In ActiveSheet.Range("TrueFalseRange").Cells
rCell.EntireColumn.Hidden = Not rCell.Value
Next
End Sub
This is causing my sheet to run very slowly. Is there something I can do to make it run faster?
I want to make a chart that changes according to the variables people select with the form control checkboxes. I'm using this code to hide the columns that are not being used, it is around 20 columns total and it takes about 10-15 sec each time I check/uncheck a box.
What would you do?
Thanks!
