title: How to trigger more than one target value simultaneously in vba
body: <p>I have a code that is triggered by user entry in column K and P:
  If any value is inserted in &quot;K&quot; then offset to corresponding cell in column R and fills the username.
  If any value is inserted in &quot;P&quot; then offset to corresponding cell in column Q and fills the data using TODAY().</p>
  <p>My code looks like:</p>
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  Dim UserName As String
  UserName = Environ(&quot;username&quot;)
  
      If Target.Column &lt;&gt; 11 Then Exit Sub
      Target.Offset(, 7).Value = IIf(Target.Value = &quot;&quot;, &quot;&quot;, UserName)
     
      If Target.Column &lt;&gt; 16 Then Exit Sub
      Target.Offset(, 1).Value = IIf(Target.Value = &quot;&quot;, &quot;&quot;, Now)
  
  
  End Sub
  </code></pre>
  <p>The problem is that it is only working with the first IF, how can I get it to work with both?</p>
  <p>Thank you in advance!!</p>