ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help Check Boxes (https://www.excelbanter.com/excel-discussion-misc-queries/86021-help-check-boxes.html)

John

Help Check Boxes
 
I need to have a check box next to a question. If it is Checked it will
unhide some cells. If it is then unchecked, it hides the cells again.

jordun

Help Check Boxes
 

Hi John

you can't hide or unhide cells. You can hide/unhide rows or columns.
You can hide the content of a cell appliying some format like a black
background. This requires some event programming attached to the
control (the check box).


--
jordun


------------------------------------------------------------------------
jordun's Profile: http://www.excelforum.com/member.php...o&userid=33118
View this thread: http://www.excelforum.com/showthread...hreadid=537496


John

Help Check Boxes
 
Sorry. I would like to hide the entire Row. So this is what i am trying to
do. I have a title in Row 4. All the information that relates to that title
is in rows 5-10. The check box is located next to the title in row 4. If
that is checked, i would like to show rows 5-10. If it is then unchecked
then everything gets hidden

"jordun" wrote:


Hi John

you can't hide or unhide cells. You can hide/unhide rows or columns.
You can hide the content of a cell appliying some format like a black
background. This requires some event programming attached to the
control (the check box).


--
jordun


------------------------------------------------------------------------
jordun's Profile: http://www.excelforum.com/member.php...o&userid=33118
View this thread: http://www.excelforum.com/showthread...hreadid=537496




All times are GMT +1. The time now is 02:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com