Hide And Unhide A Column From A Checkbox

Mar 8, 2008

I want the option of printing my form with and without a certain column. I need to hide a column when CheckBox.value=True and unhide a column when CheckBox.value=False

I keep getting errors:
Block If without End IF
End If without Block If
Else without If, when I use an else for the second If statement

Private Sub CheckBox1_Click()
Dim DescriptionCell As Range
Set DescriptionCell = ActiveSheet.Range("B:B")
If CheckBox1.Value = True Then
With DescriptionCell
.EntireColumn.Hidden = True
If CheckBox1.Value = False Then
With DescriptionCell
.EntireColumn.Hidden = False
End With
End Sub

View 3 Replies


ADVERTISEMENT

Hide And Unhide Column And Rows Using Checkbox In Excel?

Jan 28, 2013

How can i hide and unhide column and rows using checkbox in the excel.

detail price qty amount
chair 1000 1 1000

some time i just want to see only the amount or some time i want to see the qty, how can i hide and unhide row or Column

View 1 Replies View Related

Find Heading To Match CheckBox & Hide / Unhide Column

Feb 9, 2008

I need to work with the run times for some equipment. This is just hours and minutes and I get the raw data as like "Pump # 1 - 35:30". This is not date/time data per se, just a raw number of hours. I thought I would format the cells as hh:mm and for 15:00 I would just enter 15 to save time. No go, that becomes 1/15/00 00:00 and displays as 00:00. I discovered that if I just leave the formatting as general and enter 15:00 it works fine and displays right but the formula bar says 3:00 PM (Excel figured to format it hh:mm). When I enter 30:00 it again seems fine but the formula bar says Excel stores it as 1/1/00 6:00:00 AM (Excel figured to format it [h]:mm:ss but I deleted the seconds).

I can just set the formatting as [h]:mm to be consistent and enter the full 15:00 but I guess that after working that out I am just curious - can Excel store hours:minutes as just hours:minutes without turning it into a meaningless date? And without converting it to a decimal number? I don't want to total 1:30 + 1:45 = 3.25; I want the total to be 3:15. Again, it appears that [h]:mm will do what I need but it just seems unelegant to me that it is stored as some weird date and I wonder if it will cause a problem at any point.

View 6 Replies View Related

Hide/Unhide Checkbox Using Another Checkbox

Dec 14, 2008

How can i hide and unhide one checkbox using another one? Can it be done using IF formula?
And also i am using this checkbox to function something else as TRUE/FALSE.

View 6 Replies View Related

Hide Unhide Row With CheckBox ..

Sep 13, 2007

I want to create a check box which will hide/unhide a given row depending on if selected or not.

I can create a macro to hide or unhide the row, but I can't figure out how to do both depending on whether the check box is selected or not.

View 7 Replies View Related

Hide Or Unhide Rows With Using Checkbox

Mar 7, 2009

I need to hide / unhide some rows in a sheet with the help of a activex checkbox... I want remove, let's say row 20:24 and row 34 with one checkbox.

View 6 Replies View Related

Worksheet CheckBox (Hide Unhide)

May 22, 2009

I am having difficulties with this one. I have a button on my worksheet (sheet1) that runs a macro.

View 4 Replies View Related

Hide/unhide Rows Using Checkbox

Jan 20, 2010

i'm newbie here. i need to hide & unhide rows using checkbox in excel but i stuck. i write these simple code and it doesn't work at all. my bad..

View 2 Replies View Related

Hide/Unhide Rows With Checkbox

Nov 11, 2009

I've had luck with hiding rows with a checkbox, but I cannot get them to unhide when I uncheck the box.

Here's my scenario - (using Excel 2000) In an estimating spreadsheet I have a print range of A1:N74. What I'd like to do is add a checkbox or button so I can hide and unhide rows based on a null or zero in column range b5:b62. This is for printing purposes, but I can't get a 'beforeprint' event to work either. All I need is box checked and cells hide, box unchecked and cells show (unhide).

Sub CheckBox1_Click()
Dim Rng As Range
Dim MyCell As Range
Set Rng = Range("B5:B62")
For Each MyCell In Rng
If MyCell.Value = "" Then
MyCell.EntireRow.Hidden = True
End If
Next MyCell
End Sub

View 9 Replies View Related

How To Hide And Unhide Text Box By Checking A Checkbox

Jun 29, 2014

in my work sheet I need to Hide & Unhide some text box By checking a checkbox it means if user mark the check box the text box will be appear & if uncheck it the text box will be hidden

View 11 Replies View Related

Checkbox Macros Hide And Unhide On Another Sheet

Oct 22, 2012

I would like to keep the current macros that I have and add the following:

A macros that can link the check boxes with the corresponding categories and rows in the other two sheets. If the box is checked the corresponding rows in the other sheets should appear.

I have color matched the check boxes with the rows on the two other sheets I would like to be linked up with.

View 2 Replies View Related

Excel 2010 :: VBA Code That Will Hide / Unhide A Row When Used With Checkbox

Jun 22, 2014

I need a VBA code that will when used with a Form Control "Check Box" will unhide / hide a row. To be more exact, I'm needind the code to "Hide" row 34 when unchecked and "Unhide" the same row when checked. I'm using Excel 2010.

View 9 Replies View Related

Hide And Unhide Column With One Button

Mar 11, 2014

Here is my code ( Recorded by macro )

Sub Tally_Chck()
'
' Tally_Chck Macro
'
'
Columns("D:E").Select
Range("E1").Activate
Selection.EntireColumn.Hidden = True
Range("B3").Select
End Sub

I want Hide And Undie Column With One Button...
-Once Click Hide
-Again Click Unhide

View 4 Replies View Related

Column Hide/unhide Macro..

Nov 9, 2008

I am trying to hide/unhide several columns by hitting a button. It's a pretty simple macro to do it once, but how do I get a button to hide on the first click, then unhide on the second?

View 3 Replies View Related

Hide / Unhide Column With A Button

Oct 23, 2008

Using Excel 2007, I figured out how to insert a Toggle Button and program it to hide or unhide my columns F and G (which show cost data for products we sell) depending on the state of the button.

What I'd like to add to the button is text and functionality as follows:

- Columns F and G are shown, Toggle button IS NOT depressed and the button says "Hide Cost"

- Columns F and G are hidden, Toggle Button IS depressed and the button says "Show Cost"

I figured out how to change the text on the button, but can't figure out how to change it based on the button state. I know there has to be a way to do this.

View 9 Replies View Related

Use Checkbox To Hide Rows If Column Contains A Value

Sep 17, 2008

I am trying to have a checkbox that will hide any row between 6 and 300 say IF column P of that row that is empty, or does not contain the letter "Y", whichever is easier. I have found a bunch of different code snippets, but most hide a predetermined row range, and I need this to be dynamic.

If it can also expand the range automatically as I add more rows to the spreadsheet, that would be even better, but not necessarily required.

View 9 Replies View Related

Checkbox, To Perform Column Hide

May 25, 2009

I would like to have a checkbox that when checked displays a column and when not checked hides the column.
the Column to be hidden will be on a page titled "Totals"
the checkbox will be on a page called "Roster"
the column to be hidden will be "Totals!M"

now for the real problem
I am using Excel 2004 for Mac. Which does not have a "control toolbox"

what should i do. I tried to do a macro but all that does is run the macro when the object is clicked regardless of if you are checking or unchecking.

View 9 Replies View Related

Unhide/Hide Column When Choosing Dropdown List

Oct 5, 2009

Is there a way to have a column unhide one choosing a certain value from a dropdown list (validation)? I want the column to be hidden throughout the worksheet until a specific value is chosen in the list. Once it's chosen then I want it to unhide that column.

View 4 Replies View Related

Hide/Unhide Rows Meeting Condition In Column

Aug 22, 2008

In the included sheet I have 5 groups of data with five categories in column A. Current, Plan, Plan Var, Prior, Prior Var. I have included the button “Show Options” that opens the userform I created and gives 5 options. What I want is the user to be able to select any number of these options and then upon “ok” the rows in the sheet that weren’t selected are automatically hidden. If the procedure is completed again and a differen set of options is selected I want it to unhide any hidden ones that were selected and hide any that werent selected.

So if just current is selected the sheet will show 5 rows of current and nothing else. If current and prior are selected it will show current prior current prior current prior... etc.

I have some hide code that I created in the file as well.

Sub NotCurrentHide() ...

View 5 Replies View Related

Allow Hide & Unhide Column/Rows On Protected Sheet

Sep 25, 2007

I'm familiar with the code to allow grouping/ungrouping in a protected spreadsheet; http://www.ozgrid.com/Excel/outlining-protected.htm. How would I code to allow for hiding/unhiding cloumns and rows while still protecting the spreadsheet? Also, how could i allow for this file to be shared? Currently i'm getting an debug error when another person enters the file.

View 2 Replies View Related

Hide / Unhide One Row At A Time?

Dec 1, 2012

I have this file in which I have 25 empty rows in between different categories. On the side of each category there is a plus sign which is supposed to unhide an empty row below the last used one, and a minus sign which should hide the last empty row within the category (i.e. mobilization, earthworks...). I faced many problems and tried to simplify it as much as possible (trying the code for only one category, msgboxes with the values to understand what was going on) but no luck. The problem that I have been stuck at the moment is that when I try to count the rows from C73 to the last used row, it bypasses the hidden ones. I have a mess of a code and a print screen which I am attaching. printscreen.jpg

VB:
Private Sub Worksheet_BeforeDoubleClick( _
ByVal Target As Range, Cancel As Boolean)
Dim rInt As Range

[Code].....

View 3 Replies View Related

Hide Row Based On 0 Or Unhide When Less Than 0

Oct 16, 2013

Trying to hide a rows based on value being inserted to A1 = 0 (if value is >0, then unhide), but it's not working.

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("A1").Value = 0 Then
Rows("33:42").EntireRow.Hidden = True
Else
Rows("33:42").EntireRow.Hidden = False
End If

View 6 Replies View Related

Hide / Unhide Certain Rows

Apr 3, 2014

I highlighted a selection of rows and clicked HIDE, now I want to unhide certain rows and when I highlight the rows above and below and right click - unhide nothing happens. I need to Unhide to find something.

View 2 Replies View Related

Hide/Unhide The Columns

Jun 16, 2009

I've come across a spreadsheet where certain rows and columns (typically top rows or left columns) are hidden; however, there's no way to unhide them (the unhide function is grayed out) and it doesn't seem to be protected or no visible macros/vba on the file.

View 3 Replies View Related

Number & Row Hide/unhide

Sep 11, 2009

when i type 100 in the cell & press enter it automatically change to 1..and when i type 1000 i change to 10.

i have select B1 to B5 then hide it.then i click A1.how do it unhide it?

View 5 Replies View Related

Hide And Unhide Sheet According To A1 Value?

Apr 11, 2014

i want to hide my sheet if A1.value = 0(zero) and if unhide the sheet if A1.value = greater than 0(zero)

View 11 Replies View Related

VBA To UnHide / Hide Sheets

Feb 20, 2014

I have a workbook with about 20 worksheets in it.

6 are visible
3 are hidden

the remaining are very hidden

I'm creating a "welcome" page to the workbook with instructions on how to update data. The data between the 20 sheets consists of pivot tables, charts and summary data. The Visible sheets are data for management's review (all protected). The 3 hidden sheets are pivot tables that the user needs to pull data from and the very hidden sheets are not to be seen by anyone.

In my "welcome" page, I added the instructions of how to update data, but wanted an area where I could assign a checkbox or button to click on for the user to unhide my 3 hidden sheets (say Sheet1, Sheet2 and Sheet3). I do not want it to unhide my very hidden sheets. Then, when the information needed is retrieved from those sheets, I would like the user to use a checkbox or button to hide the 3 hidden sheets again. Is there a way to do this?

I tried creating custom view but couldn't do that because of the pivot tables (the option was disabled). I'm a beginner in VBA so don't even know how to begin.

View 6 Replies View Related

Hide/Unhide Columns

Dec 19, 2008

I have a spreadsheet that has 28 columns for time entries. Typically only the first 12 columns are used, so I would like to hide the remaining 16 columns (which makes the spreadsheet much more user-friendly). It would probably be nearly impossible to teach all of them how to Unhide the remaining columns (and re-Hide), plus I would like to use the full-screen function when employees enter thier times. I would like to use a form control in the column heading so that when the employees 'check' it, it will Unhide and then re-Hide the columns. Any way to do this? Seems like a VB thing to me (out of my league, but would be happy to add one in!).

View 2 Replies View Related

VBA To Unhide And Hide Columns?

Oct 23, 2002

I want to create two buttons.. one name HIDE and the other UNHIDE.

What I need hide button to do when i click it is hide the 4 columns to the right (not always going to be columns b:e)

For the unhide button unhide the 4 columns to the right (not always going to be columns b:e)

View 9 Replies View Related

VBA To Hide / Unhide Tabs

Dec 11, 2011

I am looking for a way to hide and unhide tabs. The first sheet of the workbook is an information sheet and I have a dropdown box in cell N3 to select Yes or NO to correct financial issues. If I select NO I would like to also hide tabs for sheet 4 and sheet 22.

I have used this for hiding rows:

If ActiveSheet.Cells(2, 2).Value = 0 Then Rows(146).Hidden = True

Can this be adapted to hide tabs?

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved