Drop down boxes on excel

[LouisMoore16]

I’m sure this is a really basic question for pro’s but I’m struggling to find the information online.

I’m creating a excel form which is a questionnaire. I want to create a drop down box where by selecting one of the outcome populated more boxes.

For example the drop down box will have the option for ‘house’ and ‘flat’. If you select ‘house’ it brings up further questions/text boxes relating houses and if you select ‘flat’ it brings up further questions/text boxes about flats 

Can anyone help?

[+primortal Subscriber²]

I think the only way you going to do this is building out VBA (Visual Basic for Application) Macros.

 

Something to get you started, https://stackoverflow.com/questions/35136727/show-hide-rows-per-dropdown-selection

[+Matthew S. Subscriber²]

Data Validation -> list + VBA

 

>.> I'm sort of known as an excel "wizard" at work for creating a few projects... That are still in use today, even though I'm not in that department anymore.