View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stuart[_5_] Stuart[_5_] is offline
external usenet poster
 
Posts: 413
Default CheckSpelling + TextBox

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

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.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.726 / Virus Database: 481 - Release Date: 22/07/2004