Spell check a TextBox

[Patrick C. Simonds]

Is it possible to spell check the contents of a UserForm TextBox?




---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 000755-1, 07/11/2007
Tested on: 7/11/2007 11:02:48 AM
avast! - copyright (c) 1988-2007 ALWIL Software.
http://www.avast.com

 

[old man]

Hi,

First I wrote code to copy the contents out of the textbox into a temp
document and run spellcheck on the new range but then I found a much better
(and more thorough) solution on the MVP site:

http://word.mvps.org/FAQs/MacrosVBA/SpellcheckProtectDoc.htm

old man

 

[David Sisson]

First I wrote code to copy the contents out of the textbox into a temp
document and run spellcheck on the new range but then I found a much better
(and more thorough) solution on the MVP site:

http://word.mvps.org/FAQs/MacrosVBA/SpellcheckProtectDoc.htm

This solution only works for the Forms collection, not Userforms.

Your original suggestion is the best way.

Copy the contents of the userform textbox to a new document and
perform Spellcheck. Copy the new document text back into the textbox.