Forum Discussion
dthomp74
May 28, 2020Copper Contributor
vba code assist to hide/show based on drop-down list selections
I need assistance with building a dashboard that will default to hide all rows based on "select role" and "select location" and will only produce results based when both drop-downs have changed. Can...
Lewis-H
May 28, 2020Iron Contributor
Then press Alt + F11 to open the Microsoft Visual Basic for Application window.
Double click the current open sheet name in the VBAProject section to open the Code editor.
VBA code: hide or unhide columns based on drop down list selection.
Double click the current open sheet name in the VBAProject section to open the Code editor.
VBA code: hide or unhide columns based on drop down list selection.