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 |
All times are GMT +1. The time now is 10:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com