| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to hide and unhide cells (SC).
I'm designing a form where Cell A5, which is named Off_Num. This cell
has Values (Select One, 1 to 20) in a dropdown, and Rows 9 to 28 are hidden. Now if 1 is selected in Off_Num cell then, the code should Unhide Row 9. And if 2 is selected then Row(9:10) should be unhidden so on, till if 20 is selected the Rows(9:28) should be unhidden. And if Select One option is selected that Rows(9:28) should get hidden again. Please help me with this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro or VB code to hide and unhide Label box | Excel Discussion (Misc queries) | |||
| Slow VBA code....Hide/Unhide Loop | Excel Worksheet Functions | |||
| VB Code to hide and unhide rows | Excel Discussion (Misc queries) | |||
| Hide/Unhide in Code; Protect, Unlock, etc. | Excel Programming | |||
| Code to hide and unhide columns, with certain condition? | Excel Programming | |||
Threaded Mode
