Act if spell check box occurs
 

Problem:
I have a program that checks the spelling of a cell. If the word exists,
nothing happens. Good. If the word doesn't exist, the spelling box occurs.
From there the user can choose to ignore once, ignore all, etc. Bad. I
don't want this box to appear but rather delete the offending word all
together.

One way to possibly solve?...
I am aware of how to toggle the alerts. (application.displayalerts)
I am also aware of "On Error Resume next....code....On Error GoTo 0"
I would like to combine these in a way. Something like, "On
displayalert....." Is anything like this possible?

Another thought...
When the spell check box appears (because the word wasn't in the
dictionary), the default is on the "ignore once" button. Could the macro hit
enter, know it hit enter, then delete the row? I suppose it would still need
to know that the alert appeared...

Thanks for any suggestions or help!
-Cwillis

Act if spell check box occurs
 

No code, so I don't know how you are doing it at the moment, but according
to the Help, there are 2 syntax for the CheckSpelling Method.
From what you say, I guess you are using Syntax 1, hence "Microsoft Excel
displays the Spelling dialog box".
Instead, if you used syntax 2 specifying each word you could react to return
value and delete as necessary.

NickHK

"CWillis" wrote in message
...
Problem:
I have a program that checks the spelling of a cell. If the word exists,
nothing happens. Good. If the word doesn't exist, the spelling box
occurs.
From there the user can choose to ignore once, ignore all, etc. Bad. I
don't want this box to appear but rather delete the offending word all
together.

One way to possibly solve?...
I am aware of how to toggle the alerts. (application.displayalerts)
I am also aware of "On Error Resume next....code....On Error GoTo 0"
I would like to combine these in a way. Something like, "On
displayalert....." Is anything like this possible?

Another thought...
When the spell check box appears (because the word wasn't in the
dictionary), the default is on the "ignore once" button. Could the macro
hit
enter, know it hit enter, then delete the row? I suppose it would still
need
to know that the alert appeared...

Thanks for any suggestions or help!
-Cwillis