title: How can I assign a name of this combobox(Name = Combobox1) and range it to a fixed position (Cell C4)?
body: <pre><code>With ActiveSheet.OLEObjects.Add(ClassType:="Forms.ComboBox.1",Link:=False, DisplayAsIcon:=False, Left:=50, Top:=80, Width:=100, Height:=15)
      With .Object
          .AddItem "Yes"
          .AddItem "No"
      End With
  End With
  </code></pre>
  
  <p><strong>How Can I assign a name and fix the position of it (based on the code above)?</strong></p>