title: Is there a function of excel vb that will continuously check the sheet?
body: <p>I have a combobox with the various options. For every option certain cells are formatted based on the values. </p>
  
  <p>As the values changes every few second, the program needs to keep checking to see if the conditions are satisfied. Does anyone know of a way in which the program can check the sheet every few seconds???</p>