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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.