+ Reply to Thread
Results 1 to 7 of 7

Incorrect spellings highlight and then correct them using vba

  1. #1
    Registered User
    Join Date
    07-29-2015
    Location
    new delhi
    MS-Off Ver
    2007
    Posts
    22

    Incorrect spellings highlight and then correct them using vba

    Hi i am working part time as a content writer in local news channel,

    On daily basis i write paragraphs and there are too much of spelling mistakes i do,is there any help that i can get like if want to correct spellings i just put that paragraph in that file and press button, in first highlights those spellings and ask you wish to correct? and spelling gets corrected!! Any help would do with vba would be better to save time! Is it possible?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Incorrect spellings highlight and then correct them using vba

    Why would you want a VBA solution for this when it's already a built-in feature of Word?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    07-29-2015
    Location
    new delhi
    MS-Off Ver
    2007
    Posts
    22
    Quote Originally Posted by 6StringJazzer View Post
    Why would you want a VBA solution for this when it's already a built-in feature of Word?
    Hi i don't have such idea! But it would take time to search incorrect spellings and corret them one by one...is there any vba codr or something??

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Incorrect spellings highlight and then correct them using vba

    Hi Prince,

    If you use Microsoft Word and type your words, it will show problems with spelling and punctuation as you type. I think this is what the suggestion was above. I think you'll become a better speller and writer by using Word as it shows and corrects as you type.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Incorrect spellings highlight and then correct them using vba

    There are two ways Word does spell check. One is "as you type" as explained by MarvinP. If a word is misspelled it is underlined with a squiggly line. If you right-click, then a menu will come up with suggestions for the correct spelling, and you can select one. The other way is to to spell check (Review > Spelling & Grammar) and it will stop on each misspelled word and offer a list of suggestions for the correct spelling.

    There is not really any way for VBA to improve on that.

  6. #6
    Registered User
    Join Date
    03-10-2015
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    2

    Re: Incorrect spellings highlight and then correct them using vba

    Quote Originally Posted by prince bhatia View Post
    Hi i am working part time as a content writer in local news channel,

    On daily basis i write paragraphs and there are too much of spelling mistakes i do,is there any help that i can get like if want to correct spellings i just put that paragraph in that file and press button, in first highlights those spellings and ask you wish to correct? and spelling gets corrected!! Any help would do with vba would be better to save time! Is it possible?
    Is there problem of descriptions have misspellings, or they are abbreviated, or there are two of the very same thing?

    <commercial link removed by moderator>
    Last edited by 6StringJazzer; 11-10-2015 at 08:29 AM.

  7. #7
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Incorrect spellings highlight and then correct them using vba

    rubelwatson, we do not allow links to commercial sites. Your link was completely unrelated to Excel or the question so it has been removed.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. I need a macro that can label cells in a sequence as correct or incorrect...
    By Dreamweaver8882004 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-02-2014, 12:14 AM
  2. Replies: 3
    Last Post: 06-14-2013, 12:55 PM
  3. Correct/Incorrect if cell contains letter
    By alexringo in forum Excel General
    Replies: 6
    Last Post: 06-16-2009, 07:43 AM
  4. Correct in fx; incorrect in cell
    By marvintpa in forum Excel General
    Replies: 5
    Last Post: 03-27-2009, 08:06 AM
  5. Replies: 0
    Last Post: 09-23-2008, 02:03 PM
  6. [SOLVED] A correct formula gives an incorrect figure
    By GarMcCas in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-17-2006, 06:55 PM
  7. Replies: 0
    Last Post: 07-17-2006, 03:30 PM

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