Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Check Boxes / Collapsing
I am trying to create a sheet to use for estimating. I have designed
the sheet so the various services we provide are labeled in an outline format with check boxes next to the specific service and descriptions. For Example: Key: CB = Check Box Example: TYPES OF SERVICES CB 1.1 Service 1 CB 1.1.1 Sub-Service 1 CB 1.1.2 Sub-Service 2 CB 1.1.3 Sub-Service 3 CB 2.1 Service 2 CB 2.1.1 Sub-Service 1 CB 2.1.2 Sub-Service 2 DESCRIPTION OF SERVICES CB 1.1 Service 1 - Description of service 1 is as follows..... CB 1.1.1 Sub-Service 1 - Descrption of sub-service 1 is as follows ETC.... I am wondering if there is a way for me to hide all of the descriptions of service until one of the check boxes is checked. So if CB 1.1 Service 1 is check, then the description of 1.1 Service 1 appears below and the CB is checked next to it. The goal is for an employee to check just the type of service above so that all 200 lines of descriptions aren't confusing or overwhelming when they may not be pertinent. I appreciate an help you anyone can provide. Thanks, Ryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use of Check Boxes | Excel Worksheet Functions | |||
Check Boxes | Excel Discussion (Misc queries) | |||
How do I increase the size of check in check boxes | Excel Discussion (Misc queries) | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) |