toggle

Hi all! This is a bit hard to explain so bear with me... So, I am creating a table to hold data about what tasks/jobs my team has to complete. I will be assigning these tasks for specific dates - e.g. processing orders on 31st January 2016. However some other collumns for this table are Due...

I would like to be able to toggle back and forth between 2 currencies - AUD & USD - with a conversion rate that our finance dep uses (example 0.72 right now) My spreadsheet (attached, dropbox link) is going to be full of Project costs for years, current actuals, monthly forecasts, summations...

I am not having any luck with adding toggling trendlines on or off. Ideally, when the toggle is selected, trendlines would be added and once unselected they would disappear. My chart is modified with slicers, which can cause the trendlines to disappear, therefore, the code would have to...

Hey, I'm putting together a form that involves using a lot of toggle buttons. In a nutshell there are 63 buttons that are each supposed to hide/unhide 1 of 63 rows that in turn contain six buttons. I wrote the VBA code for all of them, everything was working fine. Then when I reopened the file...

When sheet is activated, I want to turn on Snap to Grid. I've found the following code online to toggle the option, just like clicking the button, but it would be a whole lot better if anyone knows how to turn it on/off rather than just toggle...

Hi, I have searched all over and read many solutions for selecting only visible cells and copy pasting them or formatting them by doing Ctrl + G and selecting visible cells only. However the problem is once I select visible cells only, it seems that every time I do Ctrl + C on filtered Range it...

Hi, I'm trying to writea code that doesn't require stepping into vba to effect the outcome of themacro. Currently, I have acode that toggles the visibility of an array of sheets if the target cellmatches certain conditions (blue or dark blue fill). This code works great.However, I want to...

Is it possible to toggle the visibility of an array of worksheets rather than one worksheet at a time? I know this code wouldn't work if you tried, but I'm thinking something like this: Dim ShtNames as Variant ShtNames = Array("01", "02", "03") ShtNames.Visible = True I know I could run a for...

I need VBA code to toggle specific filtering in one field of a table on and off. I have a table where, in one field, I'm often toggling between the same specific criteria (let's say Crit1, Crit2 and Blanks) and clearing all filtering. If the filter criteria are not applied, then they need to be...

New to this board and looking for some help. I have a large name list (about 7000 rows), and would like to create a checkbox or toggle so the list can be sent around and the people can say yes or no to the invitation by checking the box. In the developer ribbon, I used the form control...

Could someone please respond to an ignorant Excel User with steps to: 1) Install a button 2) The macro behind the button needs to hide columns D, F, H, J 3) The same botton if pushed again unhides D, F, H, J Please respond with step by step, I am not a smarty. Thanks so much

Ok, I have searched the forum, tried using Excel Help but just can't quite figure it out. What I have created is a project management timeline spreadsheet. what i want to do is use a toggle button to hide and unhide any rows that do not contain any information in column A. sometimes not all...

I've made a togglebutton on the ribbon in Excel 2007, but I don't know how to check whether the button is pressed or not in a module. Does anyone know how to handle this problem?

I have a <toggleButton />, but I want it to be pressed if a cell value is equal to 1. I've got the following VBA code for my toggleButton: Public Sub Toggle_is_clicked(Control As IRibbonControl, pressed As Boolean) If pressed Then Range("Form").Value = 1 Else...

Hi I need to add an additional Y axis to a line graph and an additional line to go with it using a toggle button. eg: once the user clicks on the toggle button the additional line and axis will appear on the graph then click it again to remove the additional line and axis. hope this makes...

Can you toggle a button and run the code behind it by clicking another button? For example, I have a print button that once is pressed to make sure two other toggle buttons are also clicked and ran to hide unnecessary work. I don't know the expression to run code in a button where the code is...

Hi. My first question is as above. I've looked all around the forum for codes and have found many but me being such an excel noob I don't know how to adapt them to my situation. What I need is the code for a toggle Button that: ~When the toggle button is in its enabled unhides rows 15-58 and...

I have a spreadsheet that I put two buttons on. One button runs a macro that conditionally formats dates that will expire in next year and other runs a macro to undo that formating. What I want to do is have just one button - a toggle button that when clicked once shows expirations in red and...

I have two macros that hide and shows multiple sheets. I'd like to condense this to one macro so I could toggle back and forth to hide and show these sheets with a single click of a button. Can someone help me do that? Thanks... Sub showYears() Sheets("Year1").Visible = True...

As a follow-up to a previous post... I'm trying to get a macro to run on a change in a cell. Here's what I have so far: Private Sub TestClick() If Not IsEmpty(Target) Then Sheets("Sheet 3").Columns("A:A").Hidden = True Else End If End Sub So if the target cell is not empty then hide...