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
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