Hide Cells Based on a Value

[schumanp]

First time posting here..... I apologize for my ignorance.

I think I have a relatively easy task. I have a spreadsheet that contains about 75 questions that fall in 7 categories based on dollars values in 7 cells. I will outline the logic.

If F11 does not equal 0, hide rows 48 - 66

If G11 does not equal 0, hide rows 67 - 79

If H11 does not equal 0, hide rows 93 - 95

If I11 AND L11 do not equal 0, hide rows 85 - 92

If H11 does not equal 0, hide rows 96 -110

If K11 does not equal 0, hide rows 80 - 84

I have not used VBA before, but if someone could show me how to complete the first criteria, I should be able to replicate it for the rest of the results. I would also need to know how to have multiple conditions in one button.

Thank you for anyone that is kind enough to offer assistance.

Thanks,

Nick

[OfficeCoach]

Written this to unhide when conditions aren't met.

• Click on Visual Basic under the Developer tab.
• Click on the Module1 on LHS, and paste this into the editor window (and add the other logic).
• Click on Developers/Macro to run and test.
• Click on Developers/Insert/Form Controls to draw a button (and it prompts you to choose a macro (choose the name of the subroutine....eg hideQuestions)).

If Developer ribbon is not visible you can switch it on under the Excel Options box.

Please Login or Register  to view this content.

HTH

[schumanp]

Worked perfect! Thank you very much. Any books you suggest as a good reference for future solutions.

Thanks again!

[OfficeCoach]

Cheers :-)

I'm sad to say I barely use books anymore.....it's all a combination of Google, Youtube and forums like these now! Not good for the memory cells(!) but a very quick way to find solutions.