toggle

I have a bunch of slicers for a graph that work perfectly but want to find a way to have a slicer that controls the Y axis so I can toggle between two variables (Sales and volume) If I add sales and volume as a typical slicer I know it wont work because it will pull each individual value for...

Hi there I am trying to introduce a toggle in my financial model wherein if the toggle is OFF then a of the business unit's P&L and BS wont be counted towards the consolidated total. I already have the P&L and B&S in the excel and now I have to introduce the IF statement around the driver cells...

Hi all, I am trying to use toggle buttons to fill in part of a work sheet and I am trying to get if either one or more are selected the those captions will auto fill a particular cell. However my current code only fills in the final if please help.

Hi all, Could I please ask if it may be possible to have a button to toggle between the following hide/unhide columns Hide J:M Unhide O:AB Then if pressed again Unhide J:M Hide O:AB Then if pressed again revert back to the start many thanks for any help

Hello guys, I wonder if you can help me. I have a spreadsheet that has three toggle buttons. One is called "Tool," one is called "Fluid" and one is called "Air." The idea is, if I hit "Tool" it hides fluid & air rows for each account. If I hit "Fluid" it hides tool and air, and if I hit "Air" it...

I have a complicated UDF that makes hundreds of updates to the data on the screen. It takes 10-15 seconds to complete, depending on what else the machine is doing. I've seen websites that recommend adding code to such UDFs to speed them up, such as <code>Application.ScreenUpdating = False...

Feel like I'm going batty / missing something obvious. Read a cool trick to be able to toggle Conditional Formatting ("CF") on/off to see if that might be what's bogging down my file speed: simply create a new rule and move it to the TOP of all the rest of your CF rules, and click the "Stop if...

I have a custom ribbon with 2 toggle buttons both have the callback getpressed="UpOrDown" from the xml Sub UpOrDown(control As IRibbonControl, ByRef returnedVal) Select Case control.ID Case "toggle1" returnedVal = B1 Case "toggle2" returnedVal = B2 end...

hello dear friends just registered in here i have a problem in excel vba i made a user form with about 60 toggle buttons to show hide accounts in the main sheet so my problem is i wanna make a code that if change the name of the account in the sheet the caption in the toggle button changes too...

Hello, I would like to have multiple toggle buttons in excel that are independent of each other. I created two toggle buttons with the following code and get a Run-time error '1004: Method 'OLEOBjects' of object'_Worksheet' failed. How can this be fixed? Private Sub ToggleButton1_Click()...

Hello, I would like to create a toggle in Excel that changes a revenue growth percentage in a cell, this in turn spits out an internal rate of return. How do I go about automating and getting this in a summary chart? Thanks in advance. Erik

I'm running a macro that pulls up a file template, then asks you a series of questions to get the file set for who and what it needs to get the data. The problem I'm having is in having it check the appropriate checkboxes. I've never done this before, and somewhere I'm screwing up. If you...

Hello, I am working on creating a toggle button for a complicated spreadsheet. What is supposed to happen is when the toggle is pressed a formula is supposed to drive 4 investment levels keeping all four at the same ratio as when the toggle was pressed. When the toggle is released, the...

I have a beautiful looking layout that is user friendly. I have a "Heading" row that denotes a "Category" below it. I have several Categories. In each Category is a series of cells that are fill-able as an "Entry." Each Entry has it's own functions and so on. Each Entry uses the same "Template"...

I would like to filter data with the click of a button by hiding certain columns. For example when clicking, I would like to hide Columns D:H, L:Q and T:Z. And them to reappear when clicking again. I have found how to do this with one set of columns but not multiple using the following...

Hi, I'm burnt out trying to figure this one out, would appreciate the help. Below is the hide macro (which works) -> Sub Entry_Cleanup() Set Rng = Range("E3:CZ3") For Each cell In Rng If cell.Value = 0 Or cell.Value = "" Then cell.EntireColumn.Hidden = True End If Next...

I am building some shortcuts into excel and am wondering how do I make a keyboard shortcut that can toggle between different formats. I would like to create several toggles highlighted below and hopefully more thereafter: - Toggle Between Colors with “Cntrl + Shift + C” (Blue, Green, Red) -...

Here's my scenario: I have a combobox with 4 values and 4 rectangles named after the combobox values. When the value is selected from the combobox, i want the appropriate rectangle to become visible. If the value in the combobox changes, I need the visibility of the rectangles to change...

I need a VBA Button that will toggle between "Expand All" and "Callapse All" for the groupings on a given worksheet. Any help would be appreciated. Thanks!!!

Hi! I would like to have a macro that I can "toggle" on and off that will highlight all cells that have a user-inputted word. For instance, if the user inputs Available", then I would like all the cells that contain the word "Available" to highlight yellow. If I run the macro again, I would...