title: Reset Many Drop Down Boxes To Null Value Excel VBA
body: <p>I have a sheet that has a few hundred drop down boxes. I want a button that resets them all to the null or top value when clicked. I can get it to work for individual drop downs but I can't get the syntax right to loop through a group of them. I've tried everything I can think of to append "i" onto "Drop Down" but can't get it to work.</p>
  
  <p>This works fine, I don't want to write this a few hundred times:</p>
  
  <pre><code>ThisWorkbook.Sheets("sheet1").Shapes("Drop Down 260").ControlFormat.Value = 1
  </code></pre>
  
  <p>How do I get this to work:</p>
  
  <pre><code>For i = 1 To 260
      ThisWorkbook.Sheets("sheet1").Shapes("Drop Down &amp; i").ControlFormat.Value = 1
  Next i
  </code></pre>
  
  <p>I've tried <code>("Drop Down" &amp; " " &amp; "i")</code>, <code>("Drop Down" &amp; " " &amp; i)</code>, and everything else I could think of. I've exhausted Google and can't figure it out.</p>