Let me start off by saying that I have ZERO experience with VBA. I have been searching for solutions to my request and have tried numerous different codes that I have found on this site with various success. The problem is that I can't adapt the code to work with my specific need.

I have a questionnaire that I am designing. There are certain questions where a "No" answer should hide a few rows that follow the answer. I currently have it set-up with Option Button (Form Controls) to take the Yes or No answer. I have that linked to a cell and based off of that value a formula would determine which rows are hidden. For example, there are Yes/No option buttons in cell A1. Those buttons are linked to cell C1, so a click on "Yes" gives a value of 1 to cell C1 and a click on "No" gives a value of 2 in cell C1. If the user selects "No," I would like rows 2 and 3 to be hidden.

I would like to continue to use the option buttons rather than validation because I like the look of it better (plus I have already created all the necessary option buttons in the questionnaire!). If it has to be done with validation, I wouldn't totally be against it.

Any ideas on how I can get this to work?

I appreciate any help that you can give!