Use .List to populate a listbox/combobox.
Rowsource prevents adapting a listbox/combobox.
Printable View
Use .List to populate a listbox/combobox.
Rowsource prevents adapting a listbox/combobox.
Hi snb,
Sorry again for not explaining my cut instead of copy question clearly, what I am trying to do is delete the selected list box entries from the source sheet and move the remaining items in the source sheet up.
HI snub,
I'm sorry if my request regarding cut instead of paste wasn't totally clear. What I am trying to achieve is for the selections in the listBox to be deleted (cut) from the source work sheet and the remaining items in that worksheet to be moved up. Also with regard to rowsource can you give me the correct code to replace the userform rowsource - which does seem to be working ok at the moment.
Thanks in advance,
AA