Spell Checker Macro

[henrythompson]

Hi there to everyone in VBA land!

It might be a tall order but maybe someone can assist, so here goes.

I’ve a requirement to highlight where spelling errors occur in a Worksheet and so looking for a Macro to do this and ideally undo the highlighting once I’m done.

I’d preferably like the macro to identify the individual misspelt words, say by an underline or use of bold text.

Oh and if you could provide a totaliser to count the number of spelling errors detected that would be great, I've seen somethign similar using VBA in Word which does this.

Check to be performed against usual dictionary functionality.

I’ve found on-line some code which highlights the whole cell and then some which undoes the highlighting but I’d like a refinement to select just the offending words within those cells.

Thanks in anticipation.

Henry.

..............................................................
Henry Thompson
Resource Planning Officer, Programme Management Office
The National Strategies