Adjust VBA Code to Run Only When Cells in Certain Range are Changed

Hey everyone - first time poster here.

I've managed to piece together a VBA code that works perfectly for my needs. The problem is that the sheet it is on gets adjusted a lot, and I only need the code to run when certain cells are changed (rather than each time any cell is changed).

Here is the code I have now:

Please Login or Register  to view this content.

Put simply, I need this code to run only when a cell in Range "TValueDeal" is changed. Is making this adjustment as simple as adding a couple lines of code, or is there a better way to write the entire thing?

Thanks for your help.

Perfect - thank you for the quick reply!