Deleting items from a spreadsheet based off of combo box selection

you will need a loop to check to see if each of the rows contains the value DelLocationcb.Value, then select the row then delete the row

something like

Please Login or Register  to view this content.

you want to loop backward (ie largest line to smallest) since you will be deleting lines

you will need a loop to check to see if each of the rows contains the value DelLocationcb.Value, then select the row then delete the row

something like

Please Login or Register  to view this content.

you want to loop backward (ie largest line to smallest) since you will be deleting lines

I am using this code, and I'm not getting any errors associated with it, but nothing is happening. The cell is not deleting.

Thanks for your help. I decided to use screen updating. It's more practical for my use.

to ensure you get an answer that fulfills your request in full, post an example workbook that has the same layout as the one that you will be using. there is prob a small change that needs to be made to the code to get it to work. I just gave you an example code that must be modified to actually work

Hi Scott,

Perhaps you could help; based off of the code i'm using to delete items from a combo box, everything works perfect in the VBA window, but when I try to run it from the excel document itself, it's not working. Below is the code:

Please Login or Register  to view this content.

I have attached my workbook this time. This code can be found under the userform, 'MelvMaint' at the bottomMillSteel-Reports.xlsm