Can a Listbox be changed to a Combobox in VBA?

[kiddzi]

Hi,

I'm trying to change a listbox to a combobox but cannot seem to find an obvious way of doing this.

I've searched in this forum and on the web but have failed to find anything on this question.

I could just delete the current boxes and replace but am hoping there is an easy way to change as there's a lot of boxes that would need to be replaced.

Thanks in advance.

 

[Kyle123]

You can't convert them, you'll need to remove them and add comboboxes.

How many is "a lot" may be a better way of accomplishing your goal

 

[mikerickson]

Where are these boxes? On a user form or are they ActiveX on a worksheet.

You have to delete the old ComboBox and then add a new ListBox.
If you then change the name of the new ListBox to the name of the old control, then the old control's event code will control the new ListBox.