title: VBA excel combobox shapes select
body: <p>i have problem with selecting combobox after creating it via shapes object. Can someone please help?</p>
  
  <p>My code is</p>
  
  <pre><code>Dim comboBoxRange As Range
  Set comboBoxRange = Sheets(axleDataWindowName).Range("F2:F4")
  currentSheet.DropDowns.Add(20, 40, 100, 15).Name = "modifiedComboBox"
  With currentSheet.Shapes("modifiedComboBox")
      .Left = 450
      .List comboBoxRange.Value
  End With
  </code></pre>