title: macro vb script for pop up box in Excell
body: <p>I have 3 columns <code>A,B,C</code> where <code>C</code> is the ID and the rest 2 have values. If I change some values in <code>A</code> or <code>B</code> columns, I need to get a pop up message box which shows the ID of the row which was changed (EX: If I change row 10 column A value, then in the pop up it should show the ID of row 10 in column <code>C</code>).</p>
  
  <p>Please help me on this.
  Below is the script that I have tried, but I am not able to populate the column <code>C</code> value,I can only able to populate the next column value for which the value has changed (Ex: If I change the value of column <code>A</code> pop is showing the value of Column <code>B</code>, but I need the value of column <code>C</code>)</p>
  
  <p>Please find the script I am using</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
      If Not (Application.Intersect(Range("A1:C16"), Target) Is Nothing) Then
          MsgBox Target.Next &amp; "" &amp; Target.Address &amp; " has changed.", vbInformation
      End If
  End Sub
  </code></pre>