hide / unhide rows

Hello, I have a tab in my workbook that has rows that hide/unhide based off of which radio button is selected. I am wondering if there is a way to use vba to create buttons in a template to make this easy to recreate. If not, do you have any suggestions on how I could go about this smoothly? I...

Hi, I'm trying to hide rows on an excel worksheet ("ERRORS") based on whether or not a specific cell of another worksheet ("WORKFLOW") is empty. i.e.: If cell I2 of worksheet ("WORKFLOW") has any value (if it is not empty) , row 2 on worksheet ("ERRORS") should be visible. If it has no value (is...

Hi all, I'm extremely new to VBA and need assistance. I have 2 worksheets; Worksheet 1 has is a list of all employees in both department "A" & "B". Worksheet 2 is a list of employees from department "A" & their tasks for the day. I would like to create a VBA where I can enter all of my...

Hi, I have certain formatting (hiding of rows or resizing of a row) that needs to occur if new accounts are added/removed. I will have a macro button which can be run if they make any changes to the accounts. Cell K36 has a count formula and tells you how many accounts there are. Depending on...

Hello everyone! I have to sheets- Sheet1 and Sheet2 In sheet 1 I have ListBox1 with 3 values which correspond to values in cells in sheet 2(A1:A3) In Sheet 1 I have also two textbox controls textbox1 and textbox 2 allocated on the rows 10 to 15. I want to do the follwoing -whenver the...

Hi All, I am almost in the final stages of my code and I am very excited! So close to the end, I can smell it. Unfortunately this also means he code is getting trickier. What I want to accomplish: I have 2 important dropdowns with each 2 different options: 1. A / B - 2. C / D First...

I am a rebar estimator, i have a workbook that contains a quote sheet, and a pricing sheet. i have multiple products, and i want to expand with more. I currently have my quote sheet setup to hide rows using a checkbox, the checkbox also gets hidden. There is a macro that resets the Hidden status...

Helloe everyone, I am completely new to VBA so your help will be appreciated. I want automatically hide/unhide rows based on cell value. The cell value could have only 2 options: YES or NO So whenever cell value= YES then hide rows 2:10 and unhide 10:15 whenever cell value= NO then unhide...

Hey people, Just started using vba and this site has really helped me! So I thought I'd try asking with this; I'm wanting to set up a page on excel so that when B15 reads a value, it reveals the corresponding amount of rows on the page. The Values in B15 are drop box selections of: - Single -...

Hi there, I have check boxes in column L (L20:L64) which I would like to be hidden, when the row is hidden. Currently all the check boxes are clustering together on L65 when any rows are hidden. The rows start off as being hidden and once data is entered in column B, the row below is unhidden...

Hi there, Not had to write a code like this so have taken a stab in the dark but it's not liking it. Can anyone see where I am going wrong please? When I try to run it, the error highlights the second row of code (If Not Intersect...) The "Entity_Type" is located in cell D8. The "Entity Type"...

Hi there, I have the below code, which is working well at hiding and unhiding rows depending on the number of investments selected from the drop down list. In additional to my current code, I was wondering if I could go a step further and hide further rows depending on the outcome of 2x drop...

Hi there, I've got an idea but I don't have the technical ability to write it nor do I know if it's possible. Hiding rows based on a change of a formulated cell is not easy to do. In this particular example though, the data is manually entered up top and summarised down the bottom by formulas...

Hello Team, I have a workbook and containing somedata in rows but i want to show them based on cell value. Bydefault rows should be hide. I have data in. $5:$10 $13:$18 $21:$$26 I want if A1=1 and post click on button $5:$10 should be unhide and all below should be hide. Same if A1=2 and...

Hi, The sheet I am currently working on has numerous hide/unhide functions built into it. I am currently trying to to hide/unhide rows depending on the number of bank accounts selected. However, I haven't been able to get it to work at all! Can anyone see where I am going wrong? Private Sub...

I have a code that looks at Sheet4 cell A11 and if that cell is blank, hide the entire sheet. If cell A11 is NOT blank, then leave the the sheet visible, but I am looking to update this part of the code. Details: If Sheet4 cell A11 is blank, then hide the sheet. If Sheet2 cell A11 is not...

I have a tab within my workbook that has a list of client details and I am looking to delete the rows that don't match two different cell values. Here are the details: The client details data is on Sheet9 Column A starting at row 5. The cell values are Sheet1 cell C2 and Sheet10 cell A1. I...

I am looking to write VBA to hide 2 rows on Sheet10 (code name) based on cell value on Sheet1 (code name). The logic I am looking for assistance on is the following: If Sheet1 cell C33 does NOT = "Apple" then hide Sheet10 rows 108 & 109, but if cell C33 is blank, then do nothing. Thank you!

Hello All, I have been searching for threads and while I can find some code for situations similar to mine, I can't seem to re-work the code to fit my specific situation. I just don't have a deep enough understanding of VB to understand how to modify the code. I have fleshed out what I am trying...

I have VBA code to hide rows based on cell value and it works perfectly fine, but I am wondering if inserting a union into the code would make it run more efficiency as there can be many rows that need to be hidden at one time. Thoughts? Sub HideRws() Dim Rng As Range, Cl As Range With...