Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto populate w/click of a 'button' | Excel Discussion (Misc queries) | |||
How can I create a dashboard guage that reflects data? | Charts and Charting in Excel | |||
Dashboard for Excel | Excel Discussion (Misc queries) | |||
Using Option Button to populate formula | Excel Discussion (Misc queries) | |||
How do I enter data in main excel doc and have it populate subdocu | Excel Discussion (Misc queries) |