title: give a combobox in Excel a default selected value with VBA
body: <p>I have a combobox in Excel created as the picture suggests, and it has a range associated to it.</p>
  
  <p>How can I give it a default value from this range, through VBA?</p>
  
  <pre><code>ActiveSheet.Shapes("DropDown1").ControlFormat.Value = "Germany"
  </code></pre>
  
  <p>I tried the above code, but it doesn't work. I believe the syntax is not correct. Can you please help?
  Thank you!
  <img src="https://i.stack.imgur.com/DAI2y.png" alt="enter image description here"></p>