Hi all! - Jeff Weir mentioned I should post my question here...
I’d like to apply the VBA CODE from "Dynamic (Cascading) Dropdowns that reset on Change" post to the dashboard I’m building. The only issue I'm having is getting this code to work for the dependent drop down - since drop downs are in the same column, not side by side (first drop down location is in cell P9 and dependent drop down is in P13).
To map it out, I have a main dashboard sheet with drop downs in same column on right side…
“Select Academic Level” <– title above drop down
["Bachelor's", "Master's", or "Doctoral"] <— first drop down (main list) (cell P9)
{2 EMPTY ROWS, then…}
"Select Data" <— title above second, dependent drop down
[[sublist options*]] <– second drop down (cell P13)
*sublist options - depend on first drop down, but either:
Want the second drop down to reset to "Choose…" when first is selected just like in the sample file from that post, otherwise dashboard says FALSE everywhere.
I've tried but can't get the code to accommodate being in one column. FYI, I also made source and destination into a tables, but still not working; and source tables for main list and sublist are on sheet 2.
I have to keep this formatting for functionality and design (which does not include these colors, just did for clarity in post) - any help would be greatly appreciated!
Thank you!
-Amber
p.s. – Totally side question… in the end I'm hoping that this dashboard can function as a macro enabled file, but boss may want this to be translated to the web as well – do vba code/ excel files translate to javascript/the like and retain functionality? (boss not positive of the end user) Thanks!
I’d like to apply the VBA CODE from "Dynamic (Cascading) Dropdowns that reset on Change" post to the dashboard I’m building. The only issue I'm having is getting this code to work for the dependent drop down - since drop downs are in the same column, not side by side (first drop down location is in cell P9 and dependent drop down is in P13).
To map it out, I have a main dashboard sheet with drop downs in same column on right side…
“Select Academic Level” <– title above drop down
["Bachelor's", "Master's", or "Doctoral"] <— first drop down (main list) (cell P9)
{2 EMPTY ROWS, then…}
"Select Data" <— title above second, dependent drop down
[[sublist options*]] <– second drop down (cell P13)
*sublist options - depend on first drop down, but either:
- "Choose...";
- "One Year Retention", "Four Year Graduation", and "Six Year Graduation" - for "Bachelor's";
- "One Year Retention", "Two Year Graduation", and "Four Year Graduation" - for "Master's";
- "One Year Retention", "Five Year Graduation", "Seven Year Graduation", "Seven Year Graduation" - for "Doctoral"
Want the second drop down to reset to "Choose…" when first is selected just like in the sample file from that post, otherwise dashboard says FALSE everywhere.
I've tried but can't get the code to accommodate being in one column. FYI, I also made source and destination into a tables, but still not working; and source tables for main list and sublist are on sheet 2.
I have to keep this formatting for functionality and design (which does not include these colors, just did for clarity in post) - any help would be greatly appreciated!
Thank you!
-Amber
p.s. – Totally side question… in the end I'm hoping that this dashboard can function as a macro enabled file, but boss may want this to be translated to the web as well – do vba code/ excel files translate to javascript/the like and retain functionality? (boss not positive of the end user) Thanks!
