+ Reply to Thread
Results 1 to 7 of 7

Find a word and highlight it

  1. #1
    Registered User
    Join Date
    03-21-2009
    Location
    Bangalore
    MS-Off Ver
    Excel 2003
    Posts
    60

    Find a word and highlight it

    Hi Friends,

    I am new to word macros. I have a word document in that need to find a word and highlight that word. Suppose if the word occured 10 times in 10 places the word need to be highlighted. Please give me appropriate code to create a macro.


    Thanks & Regards
    Ramesh

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Find a word and highlight it

    How about this

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-21-2009
    Location
    Bangalore
    MS-Off Ver
    Excel 2003
    Posts
    60

    Re: Find a word and highlight it

    Hi Teylyn,


    Thank you for your reply. It is working in word. Could you please provide the for the same purpose.


    What I want in excel is we find a word in entire workbook and need to highlight it.


    Please kindly provide the code for excel.


    Thanks
    Ramesh

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Find a word and highlight it

    What I want in excel is we find a word in entire workbook and need to highlight it.


    Please kindly provide the code for excel.
    In which case post a new question in the Excel Programming Forum.

  5. #5
    Valued Forum Contributor
    Join Date
    07-21-2008
    Location
    London, UK
    Posts
    326

    Re: Find a word and highlight it

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    02-22-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    2

    Highlighting multiple words in MS-word 2007

    The macro works fine. I would like to know code which can highlight multiple words in different colours in excel and word. It can change the color of a cell containing the word or show a pop-out (similar to a html page) from a cell showing the highlighted text.

    Thanks in advance.

  7. #7
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Find a word and highlight it

    DTK,

    Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1