Forum Discussion

Copper Contributor

Jan 13, 2021

Using A Dropdown List To Organize Hidden Rows

I am looking for a way to hide entire rows, but use a drop down list in a specified cell where I can choose which row to make visible when needed. For example if I hide rows 5-16, and I want to u...

excel

tzaharia

Copper Contributor

Jan 14, 2021

adversi

MYList.xlsx13 KB

adversi

Iron Contributor

Jan 14, 2021

tzaharia Here are some notes on the changes made:

1. The workbook has been saved from .xlsx to .xlsm to host the VBA/macros since it needs to be Macro-enabled

2. The yellow box is where you input the row to be unhidden, with the Unhide button to active the function

3. The view the VBA, click Alt + F11 and you'll be to see them in Module1

MYList.xlsm21 KB

tzaharia
Copper Contributor
Jan 14, 2021
adversi Quick follow up. Is this set to only unhide either one row or all, or can I do multiple rows? I attempted to test it by placing the following rows in the yellow cell; "7, 8", "7 8", "7; 8", and "7: 8"

None of that worked so I'm assuming either I am not inputting the correct function elements in, or it can only do singular rows at a time. Either is fine, I just wanted to make sure I'm familiar with it's capability. Thanks again.
- adversi
  Iron Contributor
  Jan 14, 2021
  tzaharia No problem - the VBA currently allows for only a single row to be unhidden. The button unhide all will make all the hidden rows visible.
tzaharia
Copper Contributor
Jan 14, 2021
adversi This was very helpful. I appreciate that very much. This gives me a great jumping point for further evolving the functions I need. Thank you!!