Deleting records with Userform listbox selection(s)

[LewisBosworth]

Hello,
I'm not sure if this is the best way to go about this, but I have a userform where one or more values can be selected from cascading list boxe(s). Currently my code looks something like this...

Simple code and it works....almost. It certainly finds the first matching criteria and deletes the records and shifts the table contents up leaving no blanks. However, it doesn't seem to find all the matching records to delete. In this table and prior to the possibility of deleting a record, I'm resorting to bring the like categories together. While I'm not sure exactly why it's not finding all the matching records, my assumption is when I delete a row the first time it matches criteria, it is interfering with the For Each methodology. It doesn't seem to be finding the next matching. Nevertheless, this seems like a very common and basic function of userforms and applications. Can someone help me get on the right track with my current code example, or illustrate a better way? I would certainly appreciate it.

Lewis

[torachan]

lot easier to demonstrate with actual workbook.

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.