title: Excel VBA: How to get input from user and compare exact match in column D?
body: <p>Excel VBA: How to get input from user and compare exact match in column D if a match found highlight that found match  automatically in column D? Is it possible by using Excel 2013?</p>
  
  <ol>
  <li>Get input from the user  if a exact match found in column D
  highlight that value in column D (value must be type Variant) </li>
  <li>If no match found an alert msg(Not Found)</li>
  <li>Wants to clear the input text box automatically for next user input</li>
  </ol>
  
  <p>please help this will very helpful for me....</p>