title: Accessing to target values in vba simultaneously
body: <p>I have a code what it basically do is: i want to access two triggers or target values and based on their respective values, it perform on action. Ex:</p>
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Excel.Range)
  If Target.Column = 19 And Target.row = 17 Then
          If Target.Value = &quot;Yes&quot; Then
  'do something
  End if 
  End Sub
  If Target.Column = 20 And Target.row = 18 Then
          If Target.Value = &quot;Yes&quot; Then
  'do something
  End if 
  End Sub
  </code></pre>
  <p>What this does is, it only checks one trigger value at a time. When trigger1.value changes, it doesn't check trigger2.value
  However what i really wanted to do is:</p>
  <pre><code>if triger1.value = &quot;Yes&quot; and triger2.value = &quot;yes&quot; then 
  '' do something
  elseif triger1.value = &quot;No&quot; and triger2.value = &quot;yes&quot;
  '' do another thing
  end if
  and so on
  </code></pre>
  <p>my question now is: how can i access the two triggers simultaneously and if the value one trigger is updated, it will check the second trigger value and decide what to do. Any help or suggestion is highly appreciated!</p>