CheckSpelling + TextBox

S

Stuart

If I record a macro, where I
enter text to a drawing toolbar textbox
click a cell outside of the textbox
click Tools>Spelling

then the only useful code seems to be
Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", _
IgnoreUppercase:=False _
, AlwaysSuggest:=True, SpellLang:=2057

1. How can I use this so that when user leaves the textbox,
CheckSpelling automatically runs?

2. When I recorded the macro, CheckSpelling checked my
deliberate errors in the new text. It then asked If I wished
to check the entire sheet. Can I disable this feature with
code, please?

Regards.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spellcheck a single cell 11
textbox spell check 5
spellchecking only the unlocked cells of a protected spreadsheet? 5
Spell Checking on a protected sheet 4
spellLang # for UK 2
Spell Checking on a protected sheet 3
Spell Check Macro - Move to Cell 0
spell check ranges in a do loop 2

Top