How can I replace Comboboxes?

[bralew]

Hi All,

Just a brief question. Say I wanted to change some comboboxes to textboxes within my user form, is there a method whereby
I could search say, combobox23 and replace with say, TextBox9. I don't particularly want to systematically replace the boxes
individually and give myself a headache.

Thanks

[xlnitwit]

That seems unlikely to work since you are presumably using a combobox at the moment in order to put a list in it. If you do that in code, changing the combobox to a textbox is going to cause an error.

Why do you want to change the control type? You could simply make the combobox look like a textbox- although you would likely be populating its List for no good reason.

[bralew]

I basically chose poorly. Certain data should have been put into a textbox as its non editable to a third party user. As it stands, I put them (3 in total) into a ComboBox, which probably isn't best practice.
It's not that much of an issue really, I just like the idea of the user form being tight regarding input and presentation. I could go in manually but I don't want to spoil anything until my experience grows Lol

[xlnitwit]

Textboxes are editable unless you lock them and the same goes for comboboxes. You can also hide the dropdowns to make them resemble textboxes.