View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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