Results 1 to 4 of 4

DIY Spell Check Table To Correct Data Errors using VBA

Threaded View

  1. #1
    Registered User
    Join Date
    07-31-2012
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2013
    Posts
    20

    DIY Spell Check Table To Correct Data Errors using VBA

    I have a very large data entry set that often has misspellings that the built in spell check is unable to adequately correct.

    I have attached a sample spreadsheet with 2 sheets, one for the "fixed" data (where I would like a macro to correct those spellings), and a spell check lookup sheet where I've started to compile a table with all of the incorrect spellings in column A and the correct spelling in column B.

    My question is, does anyone have some sample VBA code that can get me started in the right direction to use the spell checker table I've started to search through all of the data entered in the "Fixed" sheet and automatically start replacing any incorrect spellings with the correct spellings?

    Thank you in advance for your help!!
    Attached Files Attached Files
    Last edited by edneal2; 06-14-2017 at 10:30 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Changing Spell Check language of Vba Spell Checker
    By jhelliar in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-09-2021, 03:51 AM
  2. Excel VBA, spell check to ignore data validation and text in shapes
    By Quagmire in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-22-2016, 03:43 PM
  3. Check for errors and correct them based on specific logic
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-08-2016, 12:33 PM
  4. Replies: 1
    Last Post: 10-20-2014, 11:01 AM
  5. [SOLVED] Check cells are correct format and contain correct data
    By rikosborne in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-26-2014, 02:53 PM
  6. Replies: 0
    Last Post: 11-18-2005, 03:15 PM
  7. [SOLVED] Can I have spell check ignore errors and alert me to real words?
    By JenLynFish in forum Excel General
    Replies: 2
    Last Post: 05-09-2005, 03:37 PM

Tags for this Thread

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