toggle button

  1. T

    ToggleButton hide columns under conditions

    Hi all, I have the code below now, but when I manually hide a column (for example column C) and use the toggle button twice, column C is visible again and I want it to stay hidden. Is there a possibility to do that? Private Sub ToggleButton1_Click() Dim xAddress As String xAddress = "A:Z" If...
  2. S

    Create a ToggleButton

    I believe I would like to create a ToggleButton. With my limited development background, I believe I want to layer an invisible togglebutton over a cell, so that the user, when they click on the cell will change the visual properties between three states: TRUE - green background with...
  3. C

    Using Shapes as Toggle Buttons

    This is originally asked on Excelforum.com here is the link: https://www.excelforum.com/excel-programming-vba-macros/1262270-using-shapes-as-option-buttons.html The goal is to have about 20 shapes that are tied to each other, where if you select one "On" you can choose which shapes are...
  4. M

    Spin Button VBA

    Hi I would like toggle using a spin button left and right through cells I15, AN15, BP15, CU15, DY15, FD15, GH15, HM15, IR15, JV15, LA15, ME15. Please advise EDIT: I need help to toggle through rages using a spin button left and right. I15:AN14, AN15:BP14, BP15:CU14, CU15:DY14, DY15:FD14...
  5. DDRA Steampunk

    Am I using too many arrays?

    Solved right after initial post (by experimenting). :stickouttounge: I need to autohide a crazy huge number of rows in one sheet, it currently has 9 sub tables (see Sample 2), and may need 11. Page not included because it's about 10 paper sheets long. Trying to get all arrays on one toggle...
  6. A

    Hide/Unhide toggle button which changes colour and text in vba

    Hello I've been trying to write some VBA to set up a toggle button to hide multiple predefined columns. I initially managed to define the code for the hide/unhide toggle and attached this to a shape I then wanted a toggle button which would then change the colour of the button and text...
  7. DDRA Steampunk

    How would I combine button 1 and 2? Can I use a With?

    I know I can combine more than one function on a button (as I have on each of these buttons), but I had no luck trying to combine the 2 buttons into 1. Seems like I should be able to do it with a "With" but I can't seem to make it work. I think it must have something to do with where I place the...
  8. A

    Display only columns with certain text

    Hi all, Please teach me how I can display only columns with certain text in Excel 2007? There are a lot of help on filtering rows but I am hoping to create either a toggle button or set up a reference cell (say "B4") along with a VBA to display columns with selected days only. For example...
  9. N

    VBA Toggle Button to change functionality

    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...
  10. K

    Using a Toggle Buttons to Hide Rows Based of a Value or Text in a Column

    I am trying to use macros to hide certain rows based on a value of a column which is usually a text value. I am planning a using multiple toggle buttons to hides rows that don't meet each criteria. I am kinda lost on how to begin any help and advice to get me through this would be greatly...
  11. L

    Several Toggle Buttons with same Macros

    Hi I have created a code for a Toggle button. However I need 50+ toggle buttons in the file with the same code. Please, see the code below. Private Sub ToggleButton1_Click() If ToggleButton1.Value = True Then ToggleButton1.Value. Caption = "Include" Range ("I5"). Value = 1 Else...
  12. F

    How to link Toggle Button name to Value in Excel Worksheet

    First time post... so be easy on me. I've entered a user form toggle button and now I need to link the name of this toggle button to a cell value within the worksheet the form will be placed. The cell value will change dependent on other slicers the user selects, so I need the toggle button...
  13. R

    Remove VBA loop on all worksheets.

    Can anyone help me with a simple problem. I don't know much about VBA but can tweak code I find online to do some applications. I want to use a toggle button to hide a range, but only do this on the worksheet that the toggle button is active on. The code I found on-line is for all worksheets...
  14. E

    Toggle button for hide/unhide columns

    Hi, I have a task for my student project in front of me that I need to do.. I have looked in all kind of forums but unfortunately I had no chance finding the solution for my problem.. Being a absolute beginner in Excel I need someone to help me. I use Excel 2010 and I need to do next task.. I...
  15. D

    Toggle Unhide rows but wants to prompt a password to use

    I want to be able show a prompt to add in the password before being able to do the actions below. Private SubToggleButton2_Click() If ToggleButton2Then ActiveSheet.UnprotectPassword ToggleButton2.ForeColor = RGB(0, 0, 0) ToggleButton2.Font.Bold = False ToggleButton2.Caption...
  16. C

    VBA Toggle button to remove shapes on worksheet.

    Hello. I have a number of shapes on my worksheet (text boxes, arrows and so on). I am trying to create a button that when pressed will hide (visible =false) the shapes on the worksheet. And when pressed again will show the shapes again. Can someone help me with that? Thanks
  17. O

    Clear Form and Reset Toggles on Multiple Sheets

    I am trying to reset/clear multiple sheets in an excel document as well as resetting the toggle buttons to "True". I can get the information to clear from all sheets and the toggles to reset on the active sheet but can't get the toggles from the 2 others sheets to reset. My clear button is on...
  18. M

    Toggle Button UI Ribbon

    Hi, I have added a toggle button to my custom Tab. The toggle is intended to Show/Hide a Column in the active sheet. The button works fine, but my problem is when the user saves and closes the spreadsheet. After re-opening the spreadsheet the toggle button is switched off (Not highlighted)...
  19. T

    Toggle Button to Format Cells

    Hi All, I am trying to code a toggle button to format a block of cells. Because I can only hide entire rows or columns, I am trying to just format the block of cells as ;;; so that the contents are hidden instead. If anyone can give me some code to do this, and show how to specify the cells...
  20. J

    [QUESTION] VBA CODE HELP: Only one toggle button to unhide one row at a time (there are 20 rows, but don't want them all unhidden at once)

    Hi, I have be looking all over the internet trying to find out who on earth figured this out. I don't know what to call this process or what others are calling it to effectively find the answer. I thought using keywords like: looping, repeat, one row at a time, continuous, and continuously...

Some videos you may like

This Week's Hot Topics

Top