toggle button

I have the following macro for hiding/unhiding a group of rows based on whether or not they contain empty text strings. I was hoping to insert a button that would hide or unhide the rows each time you hit it. However, I haven't done much work with buttons and assigning controls. Any help would...

I would like to set the value of a toggle button when the userform is opened so that it coincides with the what columns are hidden on screen. Below is simple example which I have not tested or debugged. It was just what i was thinking. Does anyone have any suggestions? Mr. Users have been a...

I am new to Excel VBA and this may seem like a silly question, but every time i click my toggle button the font shrinks to the point I can barely make out what it says. This is the code i've used for my toggle button. Any help is much appreciated :)

Hey everybody, this is my first post and my chosen name is not because I'm such an Excel genius... :( Anyhow, for the last three days I'm trying to figure out how to handle these silly toggle buttons. It's the first time that I try to deal with macros (can you actually already call them...

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'm trying to create a macro to reset the information in my worksheet to its original settings/ cell values however I have two toggle buttons in the worksheet. I thought I could just insert: If ToggleButton1.Value = False Then ToggleButton1.Value = True End if As you can see from my post...

Learning on my own, forgive stupidity please. I have a spreadsheet with 100 toggle buttons that when true/false will show/hide the comments of a cell. Private Sub ToggleButton1_Click() Range(ToggleButton1.LinkedCell).Select If ToggleButton1.Value = True Then...

Hi all, I am wondering if a macro could hide/unhide rows by a caterogry. To be clear, I have Names in the D column, let's for simplicity say there are 2 names nancy and in a different row there's sue and there are multiple instance of them on many different rows. I wish to be able to hit a...