PDA

View Full Version : Replace Combobox with Listbox ...



vodkasoda
04-07-2009, 11:33 AM
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
04-07-2009, 11:41 AM
Just create a combobox, delete the listbox, then rename it to whatever the listbox was. Then try it.

vodkasoda
04-07-2009, 05:08 PM
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 :doh: !!!