Aha! This article is one edition later than the one I was citing.

http://msdn.microsoft.com/archive/de...xlchkexcel.asp

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jon Peltier" wrote in message
...
FWIW, the original article was in the Microsoft Office Developer's Forum
at:

http://www.microsoft.com/exceldev/articles/chkExcel.htm

AFAICT, it no longer exists.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jon Peltier" wrote in message
...
So far I can't find the original source for my technique. The article was
based on Office 97, and while it would work fine on subsequent versions,
a lot of good Office 97 content has disappeared.

This short article has the gist of my approach:

http://www.fabalou.com/Access/Genera...spellcheck.asp

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"LuisE" wrote in message
...
Dale,

Did you fink the likn Jon was talking about? Could you please provide me
with it?
I think this apporach is better than the other than doesn't give you the
option to edit the misspelled word
Thanks in advance,

LuisE

"Dale Fye" wrote:

Thanks for your ideas guys.

I'll play around with it and see what happens. Jon, do you recall,
did you
instantiate Word(hidden), copy the text from the textbox into a Word
document, run the Word spell checker, if a misspelling is found, make
Word
visible, then, if there were changes, copy the text back, then close
Word.

That is what I am thinking of doing.

You gotta wonder why the objects and methods available to the various
elements of Office are not more tightly coordinated (methods available
in one
but not in another, or the method names are different but the functions
are
similiar). As I've gotten familiar with Excel's object model, things
are
getting easier, but the range and name of functions and methods is what
is
really getting to me.

Let me step down off my soapbox. Have a nice day.


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

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


"Jon Peltier" wrote:

Several years back (deep in the archives), I found and customized an
example
from the web that actually instantiated Word to spell check a
userform's
textboxes. It showed the highlighted and misspelled word in context
of the
whole text of the textbox, and provided suggested alternatives, just
like
Word does. You could Google the words 'Word spell check in Excel',
and
probably find the same initial source I had used.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Dale Fye" wrote in message
...
Chip,

If I pass this a string (a paragraph), it tells me I have a
misspelling,
but not where it is in the string and doesn't offer any opportunity
to fix
the misspelling. Using the Range object, one of the options is
[AlwaysSuggest], which at least pops up the corrections dialog. I
saw some
code on one of the sites I searched that parsed the paragraph into
single
word strings, then ran this code on the string. But I wanted the
user to
see the word that was misspelled highlighted in the textbox, like
it does
in Access or when you run spellcheck against a Word document.
Doesn't
look like that is going to work in Excel; or if it is going to
work, I am
going to have to step through the textbox, selecting a word at a
time and
then run the application check spelling against it, but won't be
able to
get the suggested spelling dialog.

Dale

"Chip Pearson" wrote in message
...
You don't have to use a Range. In the code below, put the value
whose
spelling you want to test in the variable S.

Sub AAA()
Dim B As Boolean
Dim S As String
S = "coment"
B = Application.CheckSpelling(S) '<<< See help for options
If B = True Then
Debug.Print S & " is properly spelled."
Else
Debug.Print S & " is misspelled."
End If
End Sub

--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)



"Dale Fye" wrote in message
...
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.