Hi All,
I have an issue that should be straightforward to resolve that I (as a relative n00b) can't work out for the life of me - the idea is that based on the choice in a dropdown menu, specific rows (named ranges) would be shown or hidden accordingly. The problem is that the macro does not run automatically. Ideally I would like it to run as required as soon as I select the option from the dropdown menu, but currently I have to click elsewhere in the sheet for it to work – any ideas to correct this…?
I tried adding in:
and![]()
Please Login or Register to view this content.
at various stages but to no avail![]()
Please Login or Register to view this content.
For info: the dropdown menu is called _Lookup, and the rows of data are split into two ranges: _123 and _ABC, with the range _All being both _123 and _ABC combined. In reality I have over 20 ranges that are included in _All to include in this macro, but for the sake of this forum I limited it to two to demonstrate the issue:
Thanks!![]()
Please Login or Register to view this content.
Bookmarks