PDA

View Full Version : VBA Code that deletes entire row if "Received" is selected from Drop-Down List



qqtest
08-29-2018, 09:50 AM
I am attempting to write a VBA code that will delete the entire row of a worksheet if "Received" is selected from a Drop-Down list in column "H" titled "Status". I would like this code to be individual to the 4 sheets of the book. I have attached a version of the workbook that I am working on. Thanks in advance for any help!

Rob342
09-12-2018, 08:28 AM
qqtest
Have coded some routine to remove all "Received" when command button pressed this works on Sheet Clinical only but you can use the same code for all sheets just change the worksheet name
you need to rewrite some of your other code !
Don't forget to use option explicit this will capture the errors

Rob
See ret workbook