on and off button to populate data in a excel dashboard
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 |
on and off button to populate data in a excel dashboard
Need more details.
"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 |
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 |
All times are GMT +1. The time now is 08:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com