Adding Search Function To Delete Matching Records

Hi,

I absolutely don't comprehend a VBA search code I picked up somewhere online. I've attached a macro workbook and inside you can type words into cell C16 and search results will populate from columns A & B. That part's great.

Now, what I'd like to do is click the delete button and when clicked, it will search for matching records in column A & B and if they match... I'm thinking the code for that is <> but I'm not sure, then delete that record, and shift the cells up. Do this until the search results are empty below the delete button.

Like I said, it's probably more understandable to look at the workbook.

I'd be very thankful for any help I receive. Also, could someone please explain to me how exactly the search function works exactly>? Piece by piece?

Thanks

Please Login or Register  to view this content.

Also, is there any search code that's easier to understand than this?

I need to keep the search functionality separate from the delete functionality. And to answer your question, that's the problem, I don't know how to have the code delete the appropriate entries. That's what my question is. Here's my process.

I'm using this to search and sort through keywords. Most of the time, I like the keywords I have manually inserted in column B. Every once in a while, I have missed a keyword... for example "eat". I want to delete all records (keywords that have the word "eat" + respective number in column A) and that way "eat" is not in my keyword list. I can continue doing what I'm doing.

This search part is just a tiny piece of a much larger system.

I understand the question and it's not difficult to add the deletion part. It's pretty much the reverse of the code you already have. See Help for how Instr works.

Please Login or Register  to view this content.