Spell Check in Text Boxes

[Lee Ann]

I've searched the previous posts trying to find an answer to this question -
no luck. Is there a way to get spell check to work when the text is in a
text box? Currently, it will only check any words outside of this area.

Thanks you in advance.

 

[Lee Ann]

I'm looking forward to trying this, but can you offer some direction on how
to use it? I can get around Excel pretty well, but have never used this.

Excuse my ignorance, but I assume what you've written should be copied and
after right clicking the affected Excel workbook page, I should choose View
Code and paste it there? If this is correct, I'm unsure where to go from
there. Thanks in advance.

 

[Lee Ann]

James & Simon - I was able to follow the instructions and get the code in as
you said. I'm obviously missing something as I received the following error
message:

Run-time error "1004": CheckSpelling method of Range class failed

I am not experienced in doing this type of thing so I do apologize for all
the questions and problems. Thanks for all your help so far and hopefully
you can assist with this latest error.

 

[Lee Ann]

I was having issues with this, but determined I still had the page protected.
The spell check works, however still ignores the text boxes. Any other idea
you have would be much appreciated.

 

[Lee Ann]

Very sorry for the delay in response - I was never notified there were
additional responses. I tried all ideas listed in your previous two posts.
The text box is under the ActiveX Controls. I checked the properties and
changed anything that gave an indication this was a protected object. I also
put some text in a cell and also added a graphic with some misspelled text.
The spell check worked everywhere except in the text box. I tried both of
the subs and each of them worked the same - still not in the text boxes. I'd
be glad to send what I've done if you're willing to take a look at it.

 

[Lee Ann]

I'm getting a Compile Error: Syntax error. When it brings up the macro
after getting the error, there are changes in what was originally put in -
the first line is highlighted in yellow:

Public Sub SpellCheckActiveXTextBoxes()


It has then put " after the first MsgBox "Spelling for this ActiveX control
has been" and has made the word 'checked' red.

Where the second MsgBox string is, it has again put " after have and shows
the 'been checked' in red.

I've pasted a copy below:

MsgBox "Spelling for this ActiveX control has been"
checked."
End If
On Error GoTo 0
Next

MsgBox "Done - spelling for all ActiveX controls on this sheet have"
been checked!"

 

[Lee Ann]

Thank you for being so patient - that worked!!

Just another question if it's a quick solution - the document I am using
this on is for evaluating personnel. They are evaluated on a daily basis and
4 forms (workbook pages) are being completed each day for a period of 14
days. The second tab is the only one where the evaluator is writing in the
ActiveX text boxes. There are 10 pages to that document - 2 text boxes per
page (total of 20 text boxes for each tab). This code has it checking all of
the text boxes - is there any simple way to tell it to stop when it sees no
more text? The evaluators usually don't use any more than 4 pages (8 text
boxes total) when they fill this form in.

Again, if it's not simple, don't worry about it - what you've done already
will make alot of people happy.

Thanks so much.

 

[Lee Ann]

This worked, but it was a little unpredictable in the path it chose when
checking the boxes. I'm just going to stick with the original code.

Thanks again for all your assistance!

 

[Lee Ann]

Well, now that you brought that up, I had to try it. I like this one and I
thank you. I suspect always trying to "enhance" makes people such as
yourselves as knowledgeable as you are.

Thanks again!