Spell Checking TextBox on UserForm

  • Searching I found code to spell check a text box on a userform. I created the following function.

    It works fine except that it is very slow. With everything spelled correctly a text box with 34 words takes 27 seconds to run. One with 11 words takes 10 seconds. It is the Application.CheckSpelling that is taking a long time. Anyone have any suggestions on speeding this up?


    Thanks

    Don

  • Hello,


    With the information you have provided ... you should double-check your Variant varWords ... ;)


    Hope this will help

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Typo in the code section in the original post. Corrected.


  • I running this at work on a 12 year old PC running Windows 7 and a not up to date office version. I’ll have to try it at home which has current hardware and software to see what the timings are.


    Thanks for the assistance.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!