Consulting

Results 1 to 2 of 2

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

  1. #1
    VBAX Newbie
    Joined
    Aug 2018
    Posts
    3
    Location

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

    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!
    Attached Files Attached Files

  2. #2
    VBAX Mentor
    Joined
    Apr 2009
    Location
    Kingsbury
    Posts
    423
    Location

    Delete row If received

    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
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •