Getting Spell Check to work in Text Form Fields

Hi,

I have a form that includes many text form fields in which people fill in
with a lot of text...how do I tell the users who fill in the form with text
to run the spell checker to check for spelling errors on what they typed
within those form fields?

Thank you

Craig

JeanGuyMarcil
Tue Apr 01 06:24:01 PDT 2008

"Craig" wrote:

> Hi,
>
> I have a form that includes many text form fields in which people fill in
> with a lot of text...how do I tell the users who fill in the form with text
> to run the spell checker to check for spelling errors on what they typed
> within those form fields?
>

See
http://word.mvps.org/faqs/macrosvba/SpellcheckProtectDoc.htm

Craig
Tue Apr 01 07:34:02 PDT 2008

Thank you.

the code works but only when the doc is unprotected...I want my users to
open the document protected, fill in all their required form fields, then
press a key like Alt S to get the macro to run the spell check of the form
fields.

How can I do this?

Thank you

Craig
"Jean-Guy Marcil" wrote:

> "Craig" wrote:
>
> > Hi,
> >
> > I have a form that includes many text form fields in which people fill in
> > with a lot of text...how do I tell the users who fill in the form with text
> > to run the spell checker to check for spelling errors on what they typed
> > within those form fields?
> >
>
> See
> http://word.mvps.org/faqs/macrosvba/SpellcheckProtectDoc.htm
>

JeanGuyMarcil
Tue Apr 01 07:54:00 PDT 2008

"Craig" wrote:

> Thank you.
>
> the code works but only when the doc is unprotected...I want my users to
> open the document protected, fill in all their required form fields, then
> press a key like Alt S to get the macro to run the spell check of the form
> fields.
>

Read the article again, maybe a bit slower tis time? ;-)

The code is designed to work with protected documents (Otherwise, if the
document is not protected, you do not need code at all...). If you get
something else as a result, you did something wrong... Not sure what... So go
back and make sure you did exactly as described in the article. Also, make
sure you copy paste the code correctly.

As a final thought, make sure you actually use the code to do the spell
check, not the built-in "Check Spelling" button on the Word toolbar.
If you want (and if you are working correctly with templates), you can
create a button and assign your macro to this button; then, copy the image
from the Word built-in button and paste it on your button. Now you can remove
the built-in one. To copy/paste a toolbar button, just right-click on the
button to access all the editing options for buttons after making sure you
are in customizing mode (Right-click any toolbar and select "Customize").

Craig
Tue Apr 01 08:52:00 PDT 2008

Sorry to bother you again, but I did exactly as in article.

I noticed that your document , Spell Check Sample, you can click Tool
Spelling and Grammar even when protected...but you can also alter text in the
unprotected section 2.

With my document, when I open it (template or not) Tools, Spelling and
Grammar is grayed out and not available, and I can not go anyway but the fill
in field...to run the code that you gave me I have to go into VBA code, and
press F5 to run it....but I dont want my users to do this...I want them to
press Tools, Spelling and Grammer, F7 key or something like Alt S

Can you tell what I am doing wrong?

Thank you very much

Craig

"Jean-Guy Marcil" wrote:

> "Craig" wrote:
>
> > Thank you.
> >
> > the code works but only when the doc is unprotected...I want my users to
> > open the document protected, fill in all their required form fields, then
> > press a key like Alt S to get the macro to run the spell check of the form
> > fields.
> >
>
> Read the article again, maybe a bit slower tis time? ;-)
>
> The code is designed to work with protected documents (Otherwise, if the
> document is not protected, you do not need code at all...). If you get
> something else as a result, you did something wrong... Not sure what... So go
> back and make sure you did exactly as described in the article. Also, make
> sure you copy paste the code correctly.
>
> As a final thought, make sure you actually use the code to do the spell
> check, not the built-in "Check Spelling" button on the Word toolbar.
> If you want (and if you are working correctly with templates), you can
> create a button and assign your macro to this button; then, copy the image
> from the Word built-in button and paste it on your button. Now you can remove
> the built-in one. To copy/paste a toolbar button, just right-click on the
> button to access all the editing options for buttons after making sure you
> are in customizing mode (Right-click any toolbar and select "Customize").

JeanGuyMarcil
Tue Apr 01 10:23:04 PDT 2008

"Craig" wrote:

> Sorry to bother you again, but I did exactly as in article.
>
> I noticed that your document , Spell Check Sample, you can click Tool
> Spelling and Grammar even when protected...but you can also alter text in the
> unprotected section 2.
>
> With my document, when I open it (template or not) Tools, Spelling and
> Grammar is grayed out and not available, and I can not go anyway but the fill
> in field...to run the code that you gave me I have to go into VBA code, and
> press F5 to run it....but I dont want my users to do this...I want them to
> press Tools, Spelling and Grammer, F7 key or something like Alt S
>
> Can you tell what I am doing wrong?
>

As I wrote in my previous post:

"As a final thought, make sure you actually use the code to do the spell
check, not the built-in "Check Spelling" button on the Word toolbar.
If you want (and if you are working correctly with templates), you can
create a button and assign your macro to this button; then, copy the image
from the Word built-in button and paste it on your button. Now you can remove
the built-in one. To copy/paste a toolbar button, just right-click on the
button to access all the editing options for buttons after making sure you
are in customizing mode (Right-click any toolbar and select "Customize")."

To add a butoon to a toolbar: With your template open and unprotected,
right-click any toolbar and select "Customize", make sure you are in the
"Commands" tab. In the "Categories" area on the left, select "Macros" (Toward
the end). Then find your macro in the "Commands" area on the right. Drag and
drop your macro onto the toolbar, next to the built-in "Check Spelling"
button (The one that is greyed out once you potect your template).
Right click the built-in Spelling button and select "Copy Button Image",
then right click on your new button and select "Paste Button Image" and also
select "Default Style" so that only the image is visible. Finally, delete the
built-in button which will be useless anyway as it is greyed out...
Exit the Customizing mode, protect your template and save it.

Now the user will have a functional "Check Spelling" button and will not
know that you replaced the built-in one with your own (unless they are
familiar with macros...)

Craig
Tue Apr 01 12:25:01 PDT 2008

You have been extremely helpful and responsive, Jean-Guy...thank you!

With your solution, as I am distributing this form out to over 20 people
over a network, it seems like I have to do the procedure of creating a button
at each person's desktop...thats over 20 times...thats why I wanted a built
in macro shortcut key like Alt +S so the user once they get my form, can then
fill it in and press Alt S to get the code you gave me to run...I guess thats
not possible. Maybe I can come up with a workaround using your code.

Thanks again

"Jean-Guy Marcil" wrote:

> "Craig" wrote:
>
> > Sorry to bother you again, but I did exactly as in article.
> >
> > I noticed that your document , Spell Check Sample, you can click Tool
> > Spelling and Grammar even when protected...but you can also alter text in the
> > unprotected section 2.
> >
> > With my document, when I open it (template or not) Tools, Spelling and
> > Grammar is grayed out and not available, and I can not go anyway but the fill
> > in field...to run the code that you gave me I have to go into VBA code, and
> > press F5 to run it....but I dont want my users to do this...I want them to
> > press Tools, Spelling and Grammer, F7 key or something like Alt S
> >
> > Can you tell what I am doing wrong?
> >
>
> As I wrote in my previous post:
>
> "As a final thought, make sure you actually use the code to do the spell
> check, not the built-in "Check Spelling" button on the Word toolbar.
> If you want (and if you are working correctly with templates), you can
> create a button and assign your macro to this button; then, copy the image
> from the Word built-in button and paste it on your button. Now you can remove
> the built-in one. To copy/paste a toolbar button, just right-click on the
> button to access all the editing options for buttons after making sure you
> are in customizing mode (Right-click any toolbar and select "Customize")."
>
> To add a butoon to a toolbar: With your template open and unprotected,
> right-click any toolbar and select "Customize", make sure you are in the
> "Commands" tab. In the "Categories" area on the left, select "Macros" (Toward
> the end). Then find your macro in the "Commands" area on the right. Drag and
> drop your macro onto the toolbar, next to the built-in "Check Spelling"
> button (The one that is greyed out once you potect your template).
> Right click the built-in Spelling button and select "Copy Button Image",
> then right click on your new button and select "Paste Button Image" and also
> select "Default Style" so that only the image is visible. Finally, delete the
> built-in button which will be useless anyway as it is greyed out...
> Exit the Customizing mode, protect your template and save it.
>
> Now the user will have a functional "Check Spelling" button and will not
> know that you replaced the built-in one with your own (unless they are
> familiar with macros...)

JeanGuyMarcil
Tue Apr 01 13:00:21 PDT 2008

"Craig" wrote:

> You have been extremely helpful and responsive, Jean-Guy...thank you!
>
> With your solution, as I am distributing this form out to over 20 people
> over a network, it seems like I have to do the procedure of creating a button
> at each person's desktop...thats over 20 times...thats why I wanted a built
> in macro shortcut key like Alt +S so the user once they get my form, can then
> fill it in and press Alt S to get the code you gave me to run...I guess thats
> not possible. Maybe I can come up with a workaround using your code.
>

If you are using a template (*.dot) you only need to do it once in the
template you designed, as I wrote in some details in my previous post.
Once you distribute that, when users create documents (*.doc) from the
template, the modification on the toolbar will be available automatically.

Whether you use my suggetion or ALT-S (or any other keyboard shortcut), if
you do not use a template, whatever it is that you do, you will have to do 20
times (A macro you create is not, by definition, built-in. So there will not
be a "built-in" short cut at each user desk connected to the macro, you will
have to create that short cut).

Again, you should work with a template, not a document.

Craig
Wed Apr 02 05:20:01 PDT 2008

Ah, this is great...I will use a template...thanks so much!

Craig

"Jean-Guy Marcil" wrote:

> "Craig" wrote:
>
> > You have been extremely helpful and responsive, Jean-Guy...thank you!
> >
> > With your solution, as I am distributing this form out to over 20 people
> > over a network, it seems like I have to do the procedure of creating a button
> > at each person's desktop...thats over 20 times...thats why I wanted a built
> > in macro shortcut key like Alt +S so the user once they get my form, can then
> > fill it in and press Alt S to get the code you gave me to run...I guess thats
> > not possible. Maybe I can come up with a workaround using your code.
> >
>
> If you are using a template (*.dot) you only need to do it once in the
> template you designed, as I wrote in some details in my previous post.
> Once you distribute that, when users create documents (*.doc) from the
> template, the modification on the toolbar will be available automatically.
>
> Whether you use my suggetion or ALT-S (or any other keyboard shortcut), if
> you do not use a template, whatever it is that you do, you will have to do 20
> times (A macro you create is not, by definition, built-in. So there will not
> be a "built-in" short cut at each user desk connected to the macro, you will
> have to create that short cut).
>
> Again, you should work with a template, not a document.
>

Craig
Wed Apr 02 07:21:06 PDT 2008

Hi The spell check works but not grammar in the form field (I made a grammar
error and spell check error in two different form fields)

While it caught the spelling error and did not catch the grammar error, I
still got the message that the spelling and grammar check is complete.

Any thoughts? Thank you!

"Craig" wrote:

> Ah, this is great...I will use a template...thanks so much!
>
> Craig
>
> "Jean-Guy Marcil" wrote:
>
> > "Craig" wrote:
> >
> > > You have been extremely helpful and responsive, Jean-Guy...thank you!
> > >
> > > With your solution, as I am distributing this form out to over 20 people
> > > over a network, it seems like I have to do the procedure of creating a button
> > > at each person's desktop...thats over 20 times...thats why I wanted a built
> > > in macro shortcut key like Alt +S so the user once they get my form, can then
> > > fill it in and press Alt S to get the code you gave me to run...I guess thats
> > > not possible. Maybe I can come up with a workaround using your code.
> > >
> >
> > If you are using a template (*.dot) you only need to do it once in the
> > template you designed, as I wrote in some details in my previous post.
> > Once you distribute that, when users create documents (*.doc) from the
> > template, the modification on the toolbar will be available automatically.
> >
> > Whether you use my suggetion or ALT-S (or any other keyboard shortcut), if
> > you do not use a template, whatever it is that you do, you will have to do 20
> > times (A macro you create is not, by definition, built-in. So there will not
> > be a "built-in" short cut at each user desk connected to the macro, you will
> > have to create that short cut).
> >
> > Again, you should work with a template, not a document.
> >

JeanGuyMarcil
Wed Apr 02 09:41:01 PDT 2008

"Craig" wrote:

> Hi The spell check works but not grammar in the form field (I made a grammar
> error and spell check error in two different form fields)
>
> While it caught the spelling error and did not catch the grammar error, I
> still got the message that the spelling and grammar check is complete.
>
> Any thoughts? Thank you!
>

The code I pointed you to is designed to handle spelling, not grammar.

I am not familiar with handling grammar checking with VBA.

I would suggest that you start a new thread for that, it might be easier to
attract other people's expertise...

But, that being said, I personally do not like the grammar checking... it
always picks up silly stuff (like passive voice, sentences with no verbs,
etc.).