+ Reply to Thread
Results 1 to 7 of 7

Check spelling in Excel, remember previous check

  1. #1
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    549

    Check spelling in Excel, remember previous check

    I doubt this can be solved.
    For every workbook, if I was to do a spell check, is there a way to disregard previously checked words?
    The list of previous checks would be related to the workbook in question, not the Dictionary provided by Microsoft (which has a similar function).
    The check may be done over a number of instances, workbook open/closed, computer shut down and restarted, workbook edited on more than 1 computer.

    The code below basically starts from scratch every time.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: Check spelling in Excel, remember previous check

    You would have to keep a record of the ranges previously checked and then exclude those from subsequent checks.
    The checking information could be stored on a hidden sheet.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    549

    Re: Check spelling in Excel, remember previous check

    You would have to keep a record of the ranges previously checked
    The issue with ranges is that rows and columns will be added in between.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: Check spelling in Excel, remember previous check

    If you store range references this should update
    If the range checked was B4:B11 on sheet1 you would store

    =Sheet1!B4:B11

    On the sheet it would return #VALUE but you can check where it refers to in VBA

  5. #5
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    549

    Re: Check spelling in Excel, remember previous check

    But the issue is that any range such as "B4:B11" may be modified with new words.

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: Check spelling in Excel, remember previous check

    Then you would need to keep a record of ranges and there contents. This would mean storing each individual cell reference rather than a range as you need to track each cell and the contents.

  7. #7
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    549

    Re: Check spelling in Excel, remember previous check

    OK, thanks. Has anything similar been done so I can use as a guide?

+ 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. How to Check spelling in a textform !
    By ajupillai in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2016, 12:18 AM
  2. Spelling Check
    By vt1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2012, 11:16 PM
  3. [SOLVED] Disabling Grammar & Spelling check in MS Word thru Excel
    By jdlc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-28-2012, 01:11 PM
  4. [SOLVED] Userform in Excel with Remember Password and User id option or check button
    By abhay_547 in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 09-17-2009, 10:38 PM
  5. Macro to check for blank cell entry, copy previous value, and check for duplicates
    By xPunxNotDeadx in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2009, 06:33 PM
  6. Change spelling check language in Excel 97
    By bwetpdpa in forum Excel General
    Replies: 1
    Last Post: 05-19-2005, 01:06 PM
  7. [SOLVED] Spelling check in excel
    By r in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2005, 06:06 AM

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