Code to Auto-Cancel a Dialogue Box

[FracinDean]

I'm trying to generate word lists that meet certain tests. I would like to use Spellcheck to decide when something is actually a word. I am able to determine if something is a word from the CheckSpelling method return value "TRUE" or "FALSE", but I have not been able to determine how to close the spell check dialogue box from within my code. I don't want the user to have to do anything to close the dialogue box, but rather to have the code do it. I always want to select the "Cancel" option for the dialogue box. I think the issue is how to programmatically respond to a dialogue box when the fact that the dialogue opened has paused the execution of your code. Here is my example code:

Dim isWord as Boolean, wordToCheck as string
Range("myWord").Select
wordToCheck = Selection.Value
isWord = Selection.CheckSpelling(wordToCheck)
Msgbox ("Result is " & isWord)

 

[footoo]

Duplicate post : https://www.mrexcel.com/forum/excel-questions/1093308-vba-cancel-dialogue.html

 

[Fluff]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).