Spell Checking TextBox on UserForm

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • 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?



  • 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 "Smiley" 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!