Code to run a Spell check

ABabeNChrist · Post by **ABabeNChrist** » 27 Feb 2010, 15:56

What might be the code to run a spell check on the open sheet

Don Wells · Post by **Don Wells** » 27 Feb 2010, 16:04

ABabeNChrist wrote:What might be the code to run a spell check on the open sheet

Try:

    Cells.Select
    Selection.CheckSpelling SpellLang:=1033

Post by **HansV** » 27 Feb 2010, 16:06

You can use

Cells.CheckSpelling

You can specify another language than the default one:

Cells.CheckSpelling SpellLang:=msoLanguageIDSpanish

Post by **HansV** » 27 Feb 2010, 16:07

Don Wells wrote:Try:
Code: Select all
    Cells.Select
    Selection.CheckSpelling SpellLang:=1033

There's no need to select the cells.

ABabeNChrist · Post by **ABabeNChrist** » 27 Feb 2010, 16:25

Thank you Don and HansV
Thats a pretty small piece of code. lol

Code: Select all

Cells.CheckSpelling

But it works good

Don Wells · Post by **Don Wells** » 27 Feb 2010, 16:29

HansV wrote: There's no need to select the cells.

I find that if cells are selected, when a spelling error is found, the cell in question is identified in the 'Name Box'. Otherwise on a large sheet the user is left to guess at the location and context.

Post by **HansV** » 27 Feb 2010, 16:42

It doesn't work that way for me in Excel 2007...

Don Wells · Post by **Don Wells** » 27 Feb 2010, 16:52

HansV wrote:It doesn't work that way for me in Excel 2007...

I'm still running 2003.

mbarron · Post by **mbarron** » 28 Feb 2010, 02:49

I'm running 2003 as well and I do not see a cell reference in the Name Box if I do the spell check in code. I do get a cell reference if I run the spell checker manually.

steveh · Post by **steveh** » 28 Feb 2010, 08:33

ABabeNChrist wrote:What might be the code to run a spell check on the open sheet

Morning

Out of interest I recorded a new macro and used the spell check on a work sheet into which a had typed a couple of dozens of lines of text and made sure some were spelt wrong, and I got this

Sub SpellIt()
'
' SpellIt Macro
' Macro recorded 28/02/2010 by Steve
'
' Keyboard Shortcut: Ctrl+k
'
Cells.CheckSpelling SpellLang:=2057
End Sub

When I tried it on some text that had again been spelt wrong it run exactly as the spell checker normally does with the dialog offering me alternatives. Like Don I too get = and a number and I guess that the difference is 1033 may be English US and 2057 may be English proper (

). I am off to Google to see if I can find out.

Editted: Reason - to correct spelling mistake!!

Post by **HansV** » 28 Feb 2010, 10:48

If you omit the SpellLang:=..., Excel will use the default language for spell checking.

Don Wells meant that the offending cell is selected, and hence its address (such as D3) displayed on the left of the formula bar when a spelling error is found. This doesn't happen if I run a spell check in code.

Don Wells · Post by **Don Wells** » 28 Feb 2010, 18:50

HansV wrote:If you omit the SpellLang:=..., Excel will use the default language for spell checking.

Don Wells meant that the offending cell is selected, and hence its address (such as D3) displayed on the left of the formula bar when a spelling error is found. This doesn't happen if I run a spell check in code.

I don't recall smoking anything unusual yesterday. Here is what happens when a spelling error is detected:

The entire sheet is selected;
Cell 'A1' is active;
The Name Box identifies the cell which was active when the macro was run; and
The Spell Check dialog box is visible, identifying the spelling error.

I suspect that yesterday I introduced the spelling error, and left the offending cell active when I ran the macro.

My humblest apologies to all for any confusion.

Mustaq · Post by **Mustaq** » 09 Jun 2022, 07:17

Supported Tags: It supports all HTML elements.

Syntax :
Syntax for spellcheck attribute in an input field in html:

<input type="text" spellcheck="value">
Syntax for spellcheck in a textarea field in html:

<textarea type="text" spellcheck="value"></textarea>

<!DOCTYPE html>
<html>
<body>
<h3>Example of Disabling SpellCheck</h3>
<form>

<p>
<input type="text" spellcheck="false">
</p>

<p>
<textarea spellcheck="false"></textarea>
</p>

<button type="reset">Reset</button>
</form>
</body>
</html>

Eileen's Lounge

Code to run a Spell check

Code to run a Spell check

Re: Code to run a Spell check

Re: Code to run a Spell check

Re: Code to run a Spell check

Re: Code to run a Spell check

Re: Code to run a Spell check

Re: Code to run a Spell check

Re: Code to run a Spell check

Re: Code to run a Spell check

Re: Code to run a Spell check (Excel 2003 SP3)

Re: Code to run a Spell check

Re: Code to run a Spell check

Re: Code to run a Spell check