Help Midifiying a Macro to add a Text to a Cell Only if it is not Present

[odoualex]

Dear All,

I have this piece of code that will add the word "Comment" at the begining of any cell that is not blank in a specific range, the problem is that the macro run after an userform load the information into the cells, so every time new information is added throught the userform the word "Comment" is added, as a result the cell will have multiples "Comment" added.
I want to modify the code so it will check if the word "Comment" is already present, if no then it will added, but if is then will do nothing.

Please Login or Register  to view this content.

[Mumps1]

Try:

Please Login or Register  to view this content.

[odoualex]

Mumps1,

Thank you for your fast response, the code is adding it to all the cells, the first condition is true for my initial code, only added if the cell is not blank. how can we combine both conditions

Thanks again for your help, your time is highly appreciated.


Respectfully,

Alex

[jolivanes]

Maybe

Please Login or Register  to view this content.

[Mumps1]

I think that jolivanes has given you the solution.

[odoualex]

Jolivanes,

Thank you very much for your help, I work perfectly!!, this solution save me a lot of time

I really appreciate your time.

Respectfully,

Alex

[odoualex]

Mumps1,

Tank you very much for your help and time, I really appreciate it.

Respectfully,


Alex

[jolivanes]

Hi Alex.
Mumps1 did all the work. I just happened to pass through and put in my two cents worth.
Anyway, you're happy so we're happy.
Good luck

[Mumps1]

Glad it all worked out.