Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

VBA UserForm - Remove values from Listbox

Avatar of Golfer219
Golfer219 asked on
Microsoft Excel
9 Comments1 Solution2330 ViewsLast Modified:
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!!
Avatar of Norie
NorieAnalyst Assistant
This problem has been solved!
Unlock 1 Answer and 9 Comments.
See Answers