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