Consulting

Results 1 to 4 of 4

Thread: Solved: Highlight word based on Excel list

  1. #1
    VBAX Regular
    Joined
    Feb 2005
    Posts
    10
    Location

    Solved: Highlight word based on Excel list

    Dear All,

    I found the macro that highlight misspelled words by Bill Coan at
    http://word.mvps.org/FAQs/MacrosVBA/HighlightSpellErrors.htm

    I also found Batch Replacer plug-in from ReplSoft website that replaces a list of words based on the entries in a worksheet list.

    I would like to extend Bill's macro and be able to do the hightlight function of Batch Replacer without closing/leaving my edited document, ie. reading column A of workbook "HighlightList.xls" and highlight all the words that appear in the workbook, in my current document.

    Could anybody kindly assist?

    Thank you in advance.

    Rid

  2. #2
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    Check out this Kb Entry.

    All you need to do is fill the collection (WordCol) with the words you want to check for. You could loop through all the cells in a given Excel range if you wanted to.

  3. #3
    VBAX Regular
    Joined
    Feb 2005
    Posts
    10
    Location
    Thank you DRJ.

    Hans had helped me with the problem. Nonetheless, it is great to know there is alternative.

    Here is the link to the discussion for the benefit of others:

    http://www.wopr.com/cgi-bin/w3t/show...b=5&o=0&fpart=

    Regards
    Rid

  4. #4
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    Glad you got it working.

    Take Care

Posting Permissions

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