Spell Check in Text Boxes

  • Thread starter Thread starter Lee Ann
  • Start date Start date
L

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.
 
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.
 
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.
 
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.
 
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.
 
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!"
 
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.
 
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!
 
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!
 
Back
Top