I have a listbox (ListBox1) on a user form of 'selected customers' which shows data from 8 columns and is linked to a named range on a sheet named 'Selected Customers'. ListBox1 also is a fmMultiSelectMulti so more than on item may be selected at a time.
I'm looking for code (most likely a loop) that will take each value that's selected in ListBox1 and will remove it from the sheet 'Selected Customers' (note - it needs to delete data in columns A through S, however it cannot delete the whole row - it can only delete those cells and move the cells up).
Thanks for your help!!