View Single Post
 
Old 03-31-2013, 09:40 AM
AlexR AlexR is offline Windows XP Office 2007
Novice
 
Join Date: Mar 2013
Location: Eastern PA, USA
Posts: 8
AlexR is on a distinguished road
Default

Well, to be honest I'm still working out the details of that, but the idea is that as the user types, the macro checks each word against a list of commonly misspelled words and a running list of frequently misspelled words specific to the user. This particular userform triggers the first few times the words are spelled correctly. A misspelling triggers a different userform that forces the user to retype the word correctly before continuing. After much research the only method I've found is to bind the macro to the spacebar and trigger it that way. I may also have to bind it to all the punctuation and closing brackets, which is ridiculous, but there doesn't appear to be a way to piggyback on Word's built-in spell checker (though its collections can be accessed with in from VBA) or to watch what the user is typing as s/he types.

I'm getting the basics from what this guy is doing here: http://www.vbaexpress.com/kb/getarticle.php?kb_id=204

The next challenge will be to maintain the running list between uses of Word, which I'll probably do by generating a text file and reimporting it. We'll see how it works out. I try to refrain from asking questions unless I'm genuinely stuck lest I use up the good will of helpful experts like yourself.
Reply With Quote