Hide rows based on answer in a drop-down box

[AndyB63]

Greetings,

I'm new here and would like some assistance on VBA coding. I have a specific query which has defeated my lack of expertise.

In one tab of a spreadsheet, I have a drop-down box (E19) with 5 possible answers, let's call them This, That, TheOther, Another, YetAnother.

Based on the option chosen, I would then like to hide rows within range rows 19 to 76.

If "This" is chosen, hide rows 19 to 28 and 41 to 76;
If "That" is chosen, hide rows 29 to 76;
If "TheOther" is chosen, hide rows 19 to 40 and 53 to 76.....and so on.

What would the VBA coding be for this?

I'd be grateful for any assistance.

 

[Dendro]

use an if function for each answer in the dropdown.
find out the syntax for hiding rows by recording macro