Hi there,
Please see attached Workbook, sheet name Form
Rows 10-14 as well as Row 21-25 is dedicated calculations for each storey. I made provision for 5 storeys. Now, I need a VBA code that, based on a selection, the lines not used, will be hidden. For example, If my selection is only Ground Story and First Storey, the rest (Rows 10,13,14,21,24,25) will be hidden.
Preferably, the selection to be done on the Glass Form, Basic information,Project info.
Is that possible?
Best Regards,and thanks in advance,
Jakes
Fenestration Calculator.xlsm
Bookmarks