Hide rows based on cell content

Hello all, I know this has been asked a lot of times, and I have tried as many varients as I can find on line with no luck.

I have a pop up box, with 5 choices. If one of those choices is selected then I need some rows to be hidden, I need this to happen automatically.

here is the code I have tried (amongst others)

Please Login or Register  to view this content.

In practice nothing happens, there is no error or anything, its just nothing happens.

I do not need to reference the pop up box if it helps, in another cell if never is picked then number 1 is displayed. But I could not work it from this either.

Many thanks

Hi garyi,

Your code works fine for me. If I have the word "never" in C13 and run the code, rows 14 to 18 are hidden.

Might you have an extra space in cell C13 like "never " or "Never" or something that doesn't match "never"?

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Hi garyi,

Go to your original message and click the green Edit button. Then below the message click "Go Advanced". Then select the text that is code and above the message area click on the "#" icon. This will put code tags around your code and make us happy.

Then explain "pop up box".

Ok Gary
I'm closer to understanding "pop up" vs "Drop Down" and you are using a validation cell.

The answer is that you need someting to trigger your code. I'm assuming the code above is located in a Module and not behind the worksheet.

You need to create an event that calls the code in your module. You do this with event code that is located behind the worksheet.

Read http://www.cpearson.com/excel/Events.aspx and then
http://www.ozgrid.com/VBA/vba-intersect.htm

Or look at my attached example that creates an event behind the worksheet that calls your code.
If I was doing it for real I'd test the cell C13 using Target and call the code only if it was what changed.