Spell Check In Excel Vba

Spell check with vba february 12 2015 marcus small i recently responded to an interesting post where someone asked for assistance with some code to check spelling for a words in specific cells.

Spell check in excel vba. We can use a for each next loop to check every cell in a worksheet. The expression tells vba to check the spelling of all the cells in sheet1. By default excel only looks at a single sheet when checking spelling.

To check only cells and notes use this method with the object returned by the cells property. You can tell it to spell check multiple sheets at once with a simple trick. For the code to work you must place it in the thisworkbook code window in vba.

In the review tab there is an option spelling as shown in the image. However this can be a bit tricky to use in excel. With your excel spreadsheet opened simply navigate to the review tab in the ribbon.

Uses of spell check in excel. Clicking this option will initiate the spell checking. Excel displays the spelling dialog box.

Before pressing f7 or the spelling button right click on any sheet tab and click select all sheets. In the review tab activate the option spelling found on the left hand side to spell check the worksheet or use the shortcuts alt r s or f7 to activate spelling. To check the spell we can either use shortcut function key f7 or from review menu tab we can use the spelling option under proofing.

Go to the review tab in the ribbon in the excel spreadsheet. Spelling check feature has been a staple in microsoft office products for a long time. Follow the below steps to perform a spell check in excel.