First time poster here so I hope I do this correctly!
Using Excel 2010
I am creating a form that will display different rows if certain selections are made. For example; cells B70-B72 are a drop down list with two options, '-' or 'sqrt'. If none equal the 'sqrt' symbol then I want to hide row 56. If one does, then row 56 will be displayed.
If this is required, the drop-down list is selecting from Sheet:'List' where D7 is 'sqrt' and D8 is '-'
There will be quite a few of these dependencies so ideally, I would be able to have many instances of the code and I could simply edit which cells are the drop down, and which cells would be shown or hidden. So for example, I could run the same code but change the drop down list to be cell B27 and then rows 36,67, and 45 would be hidden or shown.
Any help at all would be fantastic.
Thanks!
Using Excel 2010
I am creating a form that will display different rows if certain selections are made. For example; cells B70-B72 are a drop down list with two options, '-' or 'sqrt'. If none equal the 'sqrt' symbol then I want to hide row 56. If one does, then row 56 will be displayed.
If this is required, the drop-down list is selecting from Sheet:'List' where D7 is 'sqrt' and D8 is '-'
There will be quite a few of these dependencies so ideally, I would be able to have many instances of the code and I could simply edit which cells are the drop down, and which cells would be shown or hidden. So for example, I could run the same code but change the drop down list to be cell B27 and then rows 36,67, and 45 would be hidden or shown.
Any help at all would be fantastic.
Thanks!
