Excel VBA Problem!

By chibuikei ·
Hi Highly Esteemed Experts,

I have two Excel columns - A and B - and I am trying to write VBA code that will search each used field of two columns for certain keywords in this manner:
1.) If keyword is present in the first column, then populate cell D1 (for example) with a defined text.

2.) If keyword is not present in the first column A, search column B of the same record for the keywords.

I am using instr() for the search, I can successfully search the first column - does any one know how I can use instr() with select case in defining what to put in D1? to avoid lengthy and awkward if then else statements.

I am putting all these in a Do Until....Loop function.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums