title: Get the id of the selected value in a dropdown validation list on Excel in VBA
body: <p>Using Excel, lets say I have a validation list made of 5 values like this one :</p>
  
  <pre><code>Patate
  Tomate
  Courgette
  Concombre
  Patate
  </code></pre>
  
  <p>In a cell containing a drop down list made of these 5 value, I select the fifth value : "Patate". 
  I want to get in VBA that this cell contains the 5th value of my validation list. Something like :</p>
  
  <blockquote>
    <p>x = Cell.Validation.GetIDValueSelected</p>
    
    <p>x = 5</p>
  </blockquote>
  
  <p>I can't use Vertical search because I might have 2 or even more time the same value in my list (too long to explain why). 
  This list is also dynamics (depending of another sheets) so it doesn't always contains 5 values.</p>
  
  <p>I hope I made it clear for everyone to understand my needs but I will be glad to add more information if needed. 
  Thank you for your time. </p>