Help with VBA to hide/reveal rows subject to dop down selection

I have an excel template which will be used as a form completed by users

I have it set up so that certain rows are visible subject to a drop down selection

For example - one question is "how many passengers were in the vehicle", if the user selects 1 then a block of 14 rows with questions about the passenger become visible. if they select 2 then 2 x blocks of 14 rows with questions appear, and so on.

The bit I'm struggling with is if the user selects a number in error and wants to change it back - ie they select 2 then change it to 1 - I'm looking for the most efficient way to code this so that it "resets"

At the moment I've added a "reset" button which basically removes the selection altogether and hides all of the rows enabling the user to start again. But I'm hoping for a better solution so that the user can "toggle" between selections. Is this possible?

Thanks in advance!

What is your current code?
Also could you please upload a sample of your workbook?

Hi Fluff13

WARNING: I'm new to VBA so sure I've gone a long way for a shortcut with a lot of my code and it will make your brain hurt!

Current code:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Just add this

Please Login or Register  to view this content.

to the very beginning of your Passengers Sub

I have no idea how or why that works but it does, perfectly! Thanks Fluff13 for saving me endless hairpulling!!

You're welcome & thanks for the feedback.

It simply hides everything before rows etc get unhidden depending on the value in C65