Automatic running macros

Hi guys,

I have two separate macros that I want to run automatically. I have entered the script below (the first one is triggered by a change in B8 and the second one by a change in B21), however, it works for the first one only - the second one has to be run manually. Please help!

Please Login or Register  to view this content.

Thank you in advance!

Hi,

Thanks for the reply.
I am looking for the macro called "ExtendedPopulation" to run automatically when there is a change in cell B22.
The macro called "HideRows" manages to run automatically when there is a change in B9 and I don't get why the code does not work for both.

Please see the sample workbook attached.

The problem is cell B22 is not changing... it is a formula and, as such, doesn't change... what it does do is display a result when one of the cells in the range G32:G56 change. So, your code needs to monitor those cells for changing and call your macro when they do.

Yes, I just figured that out myself. However not all changes to the cells in the range G32:G56 trigger a change in B22. Is there a way to trigger the macro if the value in B22 changes as a result from the formula?

Thank you!

I think you have to handle that in your macro. I am guessing your macro does one thing if B22 contains "Yes" and something else if not... if one of G32:G56 triggers a call to the macro, the macro can simply hide rows that are already hidden or unhide visible rows over again and the user won't see any change.

Thank you for your answer. How can I make the macro hide/unhide the rows in question when a cell in the range G32:G56 is made to contain "Fail". Also how do I make it do that automatically? I am having trouble configuring it.

Thanks in advance!

Hi guys,

I figured it out! It allows the change in the result from the formula in B22 to trigger the macro. Here is the answer:

Please Login or Register  to view this content.

Thanks all for helping me!

Had a similar issue. Wound up using seperate sheets and copying back and forth. But this looks great and simpler!