+ Reply to Thread
Results 1 to 12 of 12

Spell Check a Userform in Excel using Word

  1. #1
    Registered User
    Join Date
    04-14-2017
    Location
    Chicago, IL, USA
    MS-Off Ver
    2013
    Posts
    30

    Spell Check a Userform in Excel using Word

    Hello all,

    I am having issues getting spell check to work on my userform. I have attached the code below:

    Please Login or Register  to view this content.
    I am getting an error at the following line:

    Please Login or Register  to view this content.
    error message: run-time error 4605: This method or property is not available because a document window is not active. In addition to this, when I hit end and then run the code again it works. I am not sure what the issue is.

    Thanks in advance for everyone's help!
    Last edited by Adangelo; 04-28-2017 at 09:00 AM.

  2. #2
    Registered User
    Join Date
    04-14-2017
    Location
    Chicago, IL, USA
    MS-Off Ver
    2013
    Posts
    30

    Re: Spell Check a Userform in Excel using Word

    I am still stuck on this problem. Has anyone got any ideas?

  3. #3
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Spell Check a Userform in Excel using Word

    Hi,

    You haven't properly qualified your Word objects when using them. Perhaps this will fix it
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  4. #4
    Registered User
    Join Date
    04-14-2017
    Location
    Chicago, IL, USA
    MS-Off Ver
    2013
    Posts
    30

    Re: Spell Check a Userform in Excel using Word

    XLnitwit,

    thank you for the help. I seem to be getting the same error message at the same exact line.

  5. #5
    Registered User
    Join Date
    04-14-2017
    Location
    Chicago, IL, USA
    MS-Off Ver
    2013
    Posts
    30

    Re: Spell Check a Userform in Excel using Word

    I discovered something when looking at the code. It is saying that the scratchpad is variable is being set to document2 when it should be document1, however document1 is not visible and I cannot figure out a way to access it.

  6. #6
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Spell Check a Userform in Excel using Word

    You most likely have several hidden instances of word running by now. I suggest you either close them via Task Manager and then try the code again, or reboot and then try it.

  7. #7
    Registered User
    Join Date
    04-14-2017
    Location
    Chicago, IL, USA
    MS-Off Ver
    2013
    Posts
    30

    Re: Spell Check a Userform in Excel using Word

    I have successfully rebooted the computer and the scratchpad is being set to document1, however it still will not become active which I believe is causing the error message. Should I try something completely different?

  8. #8
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Spell Check a Userform in Excel using Word

    I think you need only remove the parameter to hide the new document
    Please Login or Register  to view this content.
    rather than
    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    04-14-2017
    Location
    Chicago, IL, USA
    MS-Off Ver
    2013
    Posts
    30

    Re: Spell Check a Userform in Excel using Word

    IT WORKED! Thank you so much!

  10. #10
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Spell Check a Userform in Excel using Word

    You're welcome, and thank you for the rep.

  11. #11
    Registered User
    Join Date
    04-14-2017
    Location
    Chicago, IL, USA
    MS-Off Ver
    2013
    Posts
    30

    Re: Spell Check a Userform in Excel using Word

    I have to ask how did you figure that out? I had been working on that issue for a few weeks now and can't believe I overlooked such a simple fix.

  12. #12
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Spell Check a Userform in Excel using Word

    The error message indicated that the problem was that the window wasn't active, and I figured that was probably just because it wasn't visible.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Changing Spell Check language of Vba Spell Checker
    By jhelliar in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-09-2021, 03:51 AM
  2. Replies: 1
    Last Post: 10-20-2014, 11:01 AM
  3. Replies: 2
    Last Post: 02-06-2013, 12:13 AM
  4. Replies: 0
    Last Post: 02-05-2013, 07:51 AM
  5. Spell check embedded word docs, but not activex commanbuttons
    By Willardio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-31-2013, 11:09 PM
  6. spell check excel
    By sabrina in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-26-2005, 11:05 PM
  7. Auto spell check as in word
    By NC in forum Excel General
    Replies: 2
    Last Post: 01-27-2005, 02:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1