S
sswilcox
I've searched previous threads and have not found a solution.
Cell H40 contains the results of a calculation. If the value of H40 is
greater than 0.05 (5%), I want a message box to pop up to warn the
user. I have already written a piece of code to handle the conditions
of the message box and make it appear. No problems here.
The issue I cannot seem to work through is tying that Sub to the
Worksheet_Change event. I've tried most, if not all, of the
suggestions I've found here. I just don't see any response from my
workbook when the value in cell H40 changes. Is it because H40 is
calculated and I am not changing its value directly?
There are seven other user-entered inputs - all numeric - that
ultimately determine the number contained in H40.
I appreciate any help you can offer.
Cell H40 contains the results of a calculation. If the value of H40 is
greater than 0.05 (5%), I want a message box to pop up to warn the
user. I have already written a piece of code to handle the conditions
of the message box and make it appear. No problems here.
The issue I cannot seem to work through is tying that Sub to the
Worksheet_Change event. I've tried most, if not all, of the
suggestions I've found here. I just don't see any response from my
workbook when the value in cell H40 changes. Is it because H40 is
calculated and I am not changing its value directly?
There are seven other user-entered inputs - all numeric - that
ultimately determine the number contained in H40.
I appreciate any help you can offer.