title: Show value of specific cell in Excel macro
body: <p>I am new to excel macro.
  What I need to to is by clicking on specific cell in A column I will know It`s value. Can you help me with this?</p>
  
  <pre><code>Option Explicit
  
  Private Sub Worksheet_SelectionChange(ByVal Target As Range)
      If Selection.Count = 1 Then
          If Not Intersect(Target, Range("D1:D200")) Is Nothing Then
              MsgBox Range.("D" &amp; Row_No).Value
          End If
      End If
  End Sub
  </code></pre>