I'm interested in implementing spellchecking on a userform.

I have several textboxes that a user types into which are eventually written
to cells in an underlying spreadsheet. I've implemented a very rudimentary
spell checker which fires on the right click in the cell. But I have a
couple of issues with this.

1. The other CheckSpelling method only appears to work with a cell range,
so I have to point to a cell to be checked. So when a word the spellchecker
thinks is not valid, is found, the user cannot see this word highlighted
within the text of the textbox because the worksheet where the text is stored
is hidden. In Access, I would hilight the text programmatically, and use the
docmd.RunCommand method to run the spell checker, which would highlight the
misspelled word and make recommendations. Is there any way to accomplish
this in Excel?

2. When the spell checker is done checking the range (individual cell
actually) I have pointed it to, it asks if I want to continue checking at the
beginning of the sheet, which I don't want to do, and don't want to see. I'm
sure I could turn off the warnings before this line and turn them back on
again after, but what effect would doing so have on the spell checker?

Dale
--
Don''t forget to rate the post if it was helpful!

Email address is not valid.
Please reply to newsgroup only.