Automatic running macros

[amilchev]

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!

[mehmetcik]

The code looks ok to me.

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[amilchev]

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.

[Rick Rothstein]

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.

[amilchev]

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!

[Rick Rothstein]

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.

[amilchev]

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!

[amilchev]

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!

[Vitae]

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