title: How to detect if change in column values in Excel vba
body: <p>Is there any way to find if any value in a column going less then the permissible limit? 
  For example: 
  I have a column A   Which have variable data when making any changes effects values in column B.  </p>
  
  <p>I want to set the constraint such that if column A making any values in Column B less than 7 (by increasing or decreasing value in column A ) then that value in column A will be rejected and Column A value will not update further (Increase or Decrease). and the last value will be set as final. </p>
  
  <p>so the concept here is to loop through each Row in Column A and try to increase or decrease value until condition is satisfied. </p>
  
  <p>Note: values in column A must be positive</p>
  
  <p>Example 1: </p>
  
  <p><a href="https://i.stack.imgur.com/zGGuE.jpg" rel="nofollow noreferrer">Please follow this image link</a>
   a sample excel sheet is attached below. </p>
  
  <p>I just want a way to adjust values in column A so that column B values be in the permissible limit. ( ie. not below 7 ). This can be achieved by changing values in column A and then checking all rows of Column B for permissible limit, to achieve this I need to loop through each row in column B every time value is changed , which can take more processing time (Slowing down Vba). I need to achieve this without looping. </p>
  
  <p>TIA </p>