How to: Check Spelling in Worksheets

  • Article

Applies to

The information in this topic applies only to the specified Visual Studio Tools for Office projects and versions of Microsoft Office.

Project type

  • Document-level projects

  • Application-level projects

Microsoft Office version

  • Excel 2003

  • Excel 2007

For more information, see Features Available by Application and Project Type.

You can programmatically check the spelling of words in a worksheet. The Spelling dialog box automatically appears if there are any incorrectly spelled words in the worksheet.

To check spelling in a worksheet in a document-level customization

  • Call the CheckSpelling method of the worksheet.

    Globals.Sheet1.CheckSpelling()

    Globals.Sheet1.CheckSpelling(missing, missing, missing, missing);

To check spelling in a worksheet in an application-level add-in

  • Call the CheckSpelling(Object, Object, Object, Object) method of the active worksheet.

    CType(Application.ActiveSheet, Excel.Worksheet).CheckSpelling()

    ((Excel.Worksheet)Application.ActiveSheet).CheckSpelling
    (missing, missing, missing, missing);

See Also

Tasks

How to: Run Excel Calculations Programmatically

Concepts

Working with Worksheets

NamedRange Control

The Variable missing and Optional Parameters in Office Solutions

Change History

Date

History

Reason

July 2008

Added a code example that can be used in an application-level add-in.

Customer feedback.