Replace Combobox with Listbox ...

[vodkasoda]

I have a ComboBox in a UserForm which I want to replace with a Listbox.

Is there an *easy* way of doing this, i.e. just changing what type of box it is (I doubt it !!!).

I can obviously create a new ListBox and amend the Properties one by one to match that of the ComboBox, then delete the ComboBox, move the ListBox to where the ComboBox was in the UserForm & then go through the program replacing all the references ... but that seems a little long-winded ...

Any suggestions ?!?

[Bob Phillips]

Just create a combobox, delete the listbox, then rename it to whatever the listbox was. Then try it.

[vodkasoda]

Just create a combobox, delete the listbox, then rename it to whatever the listbox was. Then try it.

I have taken the "long-winded" route & just created a new Listbox, replaced the Combobox & amended the program where necessary ... thanks for the help & sorry for the rubbish I typed last night !!!