comment if cell contains a certain text

**kchm_2000** · 11-02-2011, 11:18 PM

Hi,

I currently have an auto commenter "ME RELATED" based on if the cell has contents that is below the input date or does not have "CCY". However i want to amend the condition such that it will not comment if the selected cell will CONTAIN CCY somewhere in the cell.
Thanks for your help

Please Login or Register  to view this content.

**Leith Ross** · 11-03-2011, 12:09 AM

Hello kchm_2000,

You can use the Like operator to check if the cell contains those characters in the cell. I have made the change to the code below.

Please Login or Register  to view this content.

**kchm_2000** · 11-03-2011, 01:05 AM

how do you turn off or on the case sensitivity?

**Leith Ross** · 11-03-2011, 01:57 AM

Hello kchm_2000,

The easiest way is to convert the string to either lower case, LCase, or to upeer case, UCase and then compare. See the change in bold.

Please Login or Register  to view this content.

**kchm_2000** · 11-03-2011, 11:26 PM

oh thanks very much, I just have one more query, How do I adjust this formula so that I can present in a case select or if else manner in one sub(). Where for instance have a first criteria in my previous formula below

Please Login or Register  to view this content.

and the second one is this

Please Login or Register  to view this content.

**Leith Ross** · 11-03-2011, 11:39 PM

Hello kchm_2000,

There are two ways to accomplish this. The first answer and easiest would be to make each maco operate only on one section. You could then create a macro using a Case statement to call each macro based on some cell value.

The other method would be to create a Function macro that took arguments and used them in the same loop. This is more complex approach. It can save space and make maintain the code easier. But, it all depends on how similar the routines are.