easy .... Combine 2 Worksheet_Change Events

[bushybob]

I'm learning VBA and I have two worksheet change events that I need to combine. The first calls a userform when the user selects "other" from a drop-down

Please Login or Register  to view this content.

With the second I am trying to monitor cell E84....everytime the cell's value changes (e.g. is recalculated), I want to compare it to cell C11. If the value in C11 is less than the calculated value in C84, I would like to display a message box.

Please Login or Register  to view this content.

Please help, explanations appreciated.

[JBeaucaire]

This is how I would do that:

Please Login or Register  to view this content.

[bushybob]

The cell E84 code is not getting called here, only the second one.

[JBeaucaire]

Small typo fixed above.

[bushybob]

It still does not fire for the E84 event

[bushybob]

Could calling the userform be ending the sub?

[JBeaucaire]

Only one cell at a time is being checked so it should trigger the first section of code if cell E84 is the one that is changed. The code looks correct, I can't advise more without being able to test it on your workbook.

[bushybob]

Okay. I just realized The message box is only triggered if you manually change the value of cell E84. Cell E84 contains a formula though and I can't change that. I need to monitor the result of the formula.

[Norie]

What's the formula in E84?

Does it contain references to any cells that are being changed manually?

[JBeaucaire]

The EVENT you may want to switch to then, is Worksheet_Calculate() event. The only problem with that is the things you want to "pop up" on the two watched cells could BOTH happen every time, it might get weird.

Please Login or Register  to view this content.

[bushybob]

I switched the cell being watched to the manual input cell that the E84 formula is linked too. Works great thank you.!

[JBeaucaire]

Very smart! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.