How to rename items within a combobox
Posted on 2007-11-16
I have a text box and a combobox. When i type a 'fault' into the textbox - the 'fault' is added to a combobox. If i want to delete a 'fault' then i can select the item from the combobox - hit delete and then the item is removed from the combobox and my worksheet data store.
However i want to add some more functionality to this part of my userform. I want the user to be able to select from the current list of faults and then rename it. Preferably using a combobox to select the fault again (as in the delete fault function) - however i am not sure how i would structure the userform such that the user could change the name of the fault selected.....
Could someone offer some tips - perhaps some code to bash at?