Adjust Value automatically when entering new value

[InterstateRentals]

This seems like it should be easy, but we're stumped! Help please!!


In simplicity: We want to be able to enter a value in cell A1 (and hit enter), but we want the value in A1 to be increased by the value saved in H1.

So: if H1 had 250 saved in it, if we enter 150 in A1 (and hit enter), we want the value in A1 to become 400.



Any help would be greatly appreciated! Thanks

[Paul]

Hi IR,

You can use the Worksheet_Change event in VBA to accomplish this task. Right-click the worksheet tab for which you want this code to run, then choose View Code.

In the VBA editor window, paste the following code then close the editor window:

Please Login or Register  to view this content.

Try it out!

Note: The EnableEvents lines prevent an infinite loop since changing the value of the target cell would continuously call the change event. The error handling was added so that if you have a non-numeric value in H1 it won't crash the macro and leave events disabled - which would stop all future macros from running until you re-enabled them.

[InterstateRentals]

Paul, thank you so much for your solution to our problem. We'll see if we can make it work! We really appreciate your help!!