Hide/Unhide rows and column based on cell value

[marshak]

HI, I need your assistance with the following:

When this Excel form is being filled out, columns H through M will be hidden and rows 9 through 21 will be hidden

Here's what I need help with: (note: cells G5 and I5 are drop downs with Yes and No answers)

If the user selects YES (cell G5), I need only rows G9:G21 to unhide
If the user selects NO (cell G5), I need columns H and I to unhide, BUT rows I9:I21 to stay hidden

THEN
If the user selects YES (cell I5), I need rows I9:I21 to unhide
If the user selects NO (cell I5), I need columns J through M to unhide

Please Note: if I picked YES in cell G5 or I5 (by mistake), and then chose NO, I need Excel to toggle/revert back and hide rows G9:G21 (or I9:I21) once NO is picked

Please see attached sample file.

Any help is greatly appreciated! THANKS SO MUCH IN ADVANCE!

[JBeaucaire]

G9:G21 is not a set of rows, it is a range of cells in a single column. To get the cells G9:G21 to be hidden, you would have to hide the ENTIRE rows 9:21.

To get the cell I9:I21 o be hidden, you would, again, have to hide the ENTIRE rows 9:21.

So a macro that is hiding rows 9:21 based on the answer of two different cells would have to check them both all the time.

Please Login or Register  to view this content.

Your two sets of "needs" appear to be incompatible.

[JBeaucaire]

Meanwhile, editing your existing macro, these tweaks seem to line up with your wants.

Please Login or Register  to view this content.

[marshak]

Thanks so much! I appreciate the help.

Another followup question: I am using the following macro. Problem is, if I mistakenly choose Yes for G5, then choose No, the unhidden rows do not revert back to hidden rows. How can I manipulate the following code to toggle between Yes/No (Unhide/Hide)?

Please Login or Register  to view this content.

[marshak]

Thanks sooooo much!! This is exactly what I needed! You are awesome, JBeaucaire!