I want help with Excel VBA code
I need a code which can replace specific word, for example "YES", in a single cell with red color of that same word, here "YES" with a red color. In addition, if this word repeats multiple times in a single cell, then it should replace all those words.
For example,
if Range("A1") has value "YES I am ok, How about you? YES, I am ok too."
Then the replacement should be "YES I am ok, How about you? YES, I am ok too."
Hi, The following code should do ask you require.
Please Login or Register to view this content.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Thank you very much!
It is working perfectly.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
hello,
simply you can go with this,
select you cells and go to "home" tab in that "clear" option click down arrow and click "clear formats"
or
simply change font color
if it is helpful to you pls change as solved query
Last edited by R Bramhendra; 09-29-2021 at 05:34 AM.
@R Bramhendra
I don't think you have understood the requirement at all. The OP wants certain words in the text formatting automatically (can only be done with VBA). How does clearing formats or changing a whole cell's font colour help? Well, it doesn't, sadly. Thanks for trying, though.
i have though like that way
its ok mam
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks