on and off button to populate data in a excel dashboard

  • Thread starter Thread starter Cryckett
  • Start date Start date
C

Cryckett

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
 
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.
 
Back
Top