Trigger code by Drop Down

**rachaelgoldman1** · 09-06-2013, 10:29 AM

Hey everyone,

I have a VBA Code which moves the entire row to the second worksheet if it contains the word "Closed" in column A. I was wondering if someone could help me make the code refer to a drop down list which I will create. For some reason, when I create the drop down list for Column A, the code no longer works. Below is the code.

Please Login or Register  to view this content.

Any help would be greatly appreciated!

Thanks!

**6StringJazzer** · 09-06-2013, 03:02 PM

Is your dropdown list a data validation list? As far as the code is concerned, a cell where "Closed" is selected from a data validation list should behave exactly the same as if the user typed "Closed" into a plain vanilla cell. Can you attach the version of your file that doesn't work? Even if you have to delete all the data except one row of fake data, that's fine, as long as the data validation is still there and you give some idea of what the data looks like.

Also note that when it comes to code, indentation is a virtue.

(Is that drive-thru burrito place still in Champaign, the one with "Burritos Bigger Than Your Head"?)