title: Don't enter in VBA macro when editing
body: <p>I have a drop down list column in an Excel worksheet to select a category. I have created a macro who replace the selected value by its ID after category selection (Worksheet_Change event). 
  Users have to fill the worksheet with ID but thank to this function, they just have to select a category in the drop down list and the ID replace the user choice.</p>
  
  <p>It work well but I have a problem: if the user wants to write directly the ID in the cell, I have an error (Invalid value) and the macro is disabled.</p>
  
  <p>How to do the difference in the Worksheet_Change between a change by the drop down list and a change by writing ? Or is there an other solution ? </p>
  
  <p>Thank you !</p>