Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkbox to hide/unhide named range
I have a chart embedded on a sheet and have named ranges that are plotted on
the chart. I would like for the user to be able to use a UserForm to select the data series on the chart. I recorded this macro to try and learn the code necessary. I have assigned it to a checkbox control, but don't know how to hide or unhide the data when the box is checked/unchecked. Below is the code. I would like the Row selection based on the "Name" to either be hidden or visible. I will assign each checkbox to the series of data that will be include on the chart. Joel Sub RemoveEarly() ' Application.Goto Reference:="TARGETEARLY" Selection.EntireRow.Hidden = True End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkbox to hide/unhide named range
Assuming a checkbox from the control toolbox toolbar:
Perhaps: Private Sub Checkbox1_Change() Worksheets("Sheet1").Range("Targetearly") _ .EntireRow.Hidden = Checkbox1.Value End Sub -- Regards, Tom Ogilvy "Joel Mills" wrote in message ... I have a chart embedded on a sheet and have named ranges that are plotted on the chart. I would like for the user to be able to use a UserForm to select the data series on the chart. I recorded this macro to try and learn the code necessary. I have assigned it to a checkbox control, but don't know how to hide or unhide the data when the box is checked/unchecked. Below is the code. I would like the Row selection based on the "Name" to either be hidden or visible. I will assign each checkbox to the series of data that will be include on the chart. Joel Sub RemoveEarly() ' Application.Goto Reference:="TARGETEARLY" Selection.EntireRow.Hidden = True End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkbox to hide/unhide named range
Tom,
It's not from the control toolbox toolbar. I have it in the VBA Project form. I'm not sure which is the best approach. My Program makes heavy use of forms from the VBA Project. For consistency I'd like to stay with this approach. "Tom Ogilvy" wrote in message ... Assuming a checkbox from the control toolbox toolbar: Perhaps: Private Sub Checkbox1_Change() Worksheets("Sheet1").Range("Targetearly") _ .EntireRow.Hidden = Checkbox1.Value End Sub -- Regards, Tom Ogilvy "Joel Mills" wrote in message ... I have a chart embedded on a sheet and have named ranges that are plotted on the chart. I would like for the user to be able to use a UserForm to select the data series on the chart. I recorded this macro to try and learn the code necessary. I have assigned it to a checkbox control, but don't know how to hide or unhide the data when the box is checked/unchecked. Below is the code. I would like the Row selection based on the "Name" to either be hidden or visible. I will assign each checkbox to the series of data that will be include on the chart. Joel Sub RemoveEarly() ' Application.Goto Reference:="TARGETEARLY" Selection.EntireRow.Hidden = True End Sub |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkbox to hide/unhide named range
Tom,
With a little work I was able to make these changes to make it work. Thanks againg for your help. Sub Series() Worksheets("Curve").Range("Targetearly").EntireRow .Hidden = ChartSeries.CheckBox1.Value End Sub "Tom Ogilvy" wrote in message ... Assuming a checkbox from the control toolbox toolbar: Perhaps: Private Sub Checkbox1_Change() Worksheets("Sheet1").Range("Targetearly") _ .EntireRow.Hidden = Checkbox1.Value End Sub -- Regards, Tom Ogilvy "Joel Mills" wrote in message ... I have a chart embedded on a sheet and have named ranges that are plotted on the chart. I would like for the user to be able to use a UserForm to select the data series on the chart. I recorded this macro to try and learn the code necessary. I have assigned it to a checkbox control, but don't know how to hide or unhide the data when the box is checked/unchecked. Below is the code. I would like the Row selection based on the "Name" to either be hidden or visible. I will assign each checkbox to the series of data that will be include on the chart. Joel Sub RemoveEarly() ' Application.Goto Reference:="TARGETEARLY" Selection.EntireRow.Hidden = True End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide / Unhide Columns with checkbox | Excel Programming | |||
hide or unhide pivotfield using a checkbox | Excel Programming | |||
Checkbox to hide and unhide rows Please. | Excel Worksheet Functions | |||
hide / unhide range | Excel Programming | |||
Checkbox Control to Hide/Unhide Worksheet | Excel Programming |