on and off button to populate data in a excel dashboard

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
 
S

ShaneDevenshire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How to populate a cell with numeric value based on textselected from pull down in adjacent cell? 1
IF function that searches a range of cells for data and provide tr 2
Populate worksheet with data that meets date range criteria 3
can excel populate fields in one worksheet to another? 6
have an entire row populate with a link when the data in a cell ch 1
Auto populate data from a table into cells after a match is found 5
Button - Macro to auto-populate data 1

Top