<div>
<div class="content wysiwyg-content">
Hi. I am using the following code to add a DropDown to a spreadsheet<br />
I need the user to be able to also type text &nbsp;in the control like a ComboBox.<br />
Is this possible? If so, how would I alter the code to do that<br />
<br />
Sub DD()<br />
<br />
With ActiveSheet.DropDowns.Add(<wbr />142.5, 38.25, 108.75, 24)<br />
&nbsp; &nbsp; .Top = Range(&quot;C1&quot;).Top<br />
&nbsp; &nbsp; .Left = Range(&quot;C1&quot;).Left<br />
&nbsp; &nbsp; .Height = Range(&quot;C1&quot;).Height<br />
&nbsp; &nbsp; .Width = Range(&quot;C1&quot;).Width<br />
End With<br />
<br />
<br />
End Sub
</div>
</div>


Hi. I am using the following code to add a DropDown to a spreadsheet
I need the user to be able to also type text  in the control like a ComboBox.
Is this possible? If so, how would I alter the code to do that

Sub DD()

With ActiveSheet.DropDowns.Add(142.5, 38.25, 108.75, 24)
    .Top = Range("C1").Top
    .Left = Range("C1").Left
    .Height = Range("C1").Height
    .Width = Range("C1").Width
End With


End Sub

Excel VBA user not able to write in a ComboBox

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.