Forum Discussion
vba code assist to hide/show based on drop-down list selections
mathetes this would have been perfect. I am checking with the administrator to see when the newest features of Office will become available to us. What would you do in the older version of Office Excel?
You asked: What would you do in the older version of Office Excel?
And my answer: I'd get the newest version.
Seriously. You won't regret it. These Dynamic Array functions are amazing in what you can accomplish. I can't even think back to how I'd do what you've asked. I have almost always, though, sought solutions other than VBA, mainly because I'm pretty much convinced that the functions available have long been able to do, more reliably and more quickly, what VBA often is used for. (I do realize macros can come in handy for some tasks, but the few times I've used them, it's for repetitive tasks -- e.g., printing a report with one variable changed in between multiple iterations -- rather than data summaries.)
Just to back that up with regard to what I just did for you: I really used only three formulas and data validation for the two cells, and that data validation referred to the results of two of the three formulas.
And a "behind the scenes" reality here: if that raw data were in the form of an Excel Table, and you were to add a region or a role, those formulas that generate the list of unique regions and roles would instantly capture the additions, adding them to the data validation lists.
FWIW, I've also just "discovered" these new Dynamic Array functions in the last month, and they're astonishingly powerful. Here's a link to a YouTube educational video put together by a Microsoft employee and sometime contributor to these pages: https://www.youtube.com/watch?v=9I9DtFOVPIg.
This is what opened my eyes to what they can do.
I, too, have knowledge of the new functions but working for the govt I am limited by IT as the administrator and when they update to the latest version.
That would be frustrating. I hope you get the newer version soon (since it's the government, for the sake of all of us)....
In the meantime, I was happy to see that hynguyen contributed a different solution. Is it working for you?
mathetes I, too, have knowledge of the new functions but working for the govt I am limited by IT as the administrator and when they update to the latest version. I have it on my Microsoft Surface but do not have access to work on that laptop. There would then be compatibility issues for other users. I have put through a request. Not sure how far that will go and timing of course unclear.