on and off button to populate data in a excel dashboard
Hi,
Populate the range with a formula like this
=IF($B$1=1,myformula,"")
where myformula is whatever formula you would use to populate these cells,
Set up your togglebutton to enter 1 in cell B1 when B1 = 0 and 0 in B1 when
B1 = 1.
The code would look like this:
Private Sub ToggleButton1_Click()
If [A5] = 1 Then
[A5] = 0
Me.ToggleButton1.Caption = "Show Detail"
Else
[A5] = 1
Me.ToggleButton1.Caption = "Hide Detail"
End If
End Sub
If this helps, click the Yes button.
--
Thanks,
Shane Devenshire
"Cryckett" wrote:
Hello,
I am working on a dashboard and my boos, wants a button that will populate
the cells below the first merge cell. I offer him a list format, however that
isn't good enough. My boss would like to be able to turn the function on and
off. allowing the cells to apear then disapear when de-selected.
Please any help is appreciated
|