Allow better control/usage of the office spellchecker
Often times I want to be able to run a spellchecker on just a single textbox, of just a single row/record. The primary textbox might contain text while other textboxes on the same form could contain references that would not make sense to spellcheck.
Ideally, as part of the beforeUpdate event of either the textbox or the form, I could run the spellchecker and react accordingly.
Anders Ebro (TheSmileyCoder) commented
Oh, and it would also be lovely to specify the language to use, as well as whether it should run silently. Some times I might want simply check if there are spelling mistakes before presenting the spell check dialog. And if the spellchecker runs, without finding any errors might also be a scenario in which I would not want to show a "No spelling errors found" messagebox.
If SpellCheck(Me.TextBoxName,"English US",vbSilent)>0 Then
Msgbox "Spelling errors found, Please correct and try again"
SpellCheck Me.TextBoxName,"English US"