Hiding rows based on content of a cell

Hello Excel Forum,

I'm rather new to VBA (if you define 'rather new' as 'never touched a line of code before'), so I've likely made some basic oversight here, but any help'd be much appreciated. I'm trying to set up a macro that will automatically hide a number of rows based on the value of a Yes/No selection from a drop down menu. While I can set the rows to hide when a cell is changed manually, I'm having difficulty getting the macro to trigger using a formula. I've tried using the method outlined in this site, but I can't seem to get it to work with both hiding and showing the rows as required.

The intention behind it is to hide elements of a form that are no longer applicable if an earlier option isn't chosen. Since there's a few such fields, I assume I'll need to assign unique names to the macros?

This is about the best I've come up with so far but I'm getting Type mismatch errors when I try to run it. As I haven't the faintest idea what it is I'm doing here, I could easily be miles off. A1 is currently set to return a value of 1 if 'Yes' is selected, and 0 if 'No' is chosen.

Please Login or Register  to view this content.

Any help would be greatly appreciated.

Brilliant, that's fixed the thing right up.

Thanks for the help.