Excel VBA user not able to write in a ComboBox

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
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
NorieConnect With a Mentor VBA ExpertCommented:
I'm afraid it's not possible to type text in a dropdown control.

You could try an ActiveX control.
    ActiveSheet.OLEObjects.Add ClassType:="Forms.ComboBox.1", Link:=False, _
        DisplayAsIcon:=False, Left:=Range("C1").Left, Top:=Range("C1").Top, Width:=Range("C1").Width, Height:= _

Open in new window

Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.