+ Reply to Thread
Results 1 to 11 of 11

Position Spell Check popup in Center of Excel Application

  1. 07-10-2019, 11:20 PM #1
    JJFletcher
    JJFletcher is offline
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    985

    Position Spell Check popup in Center of Excel Application

    Hello everyone,

    I have a UserForm that has a TextBox2 and I am wanting to perform Spell Check in that TextBox.

    The Spell Check code I have below identifies the misspelled word and Highlights the word, however I am wanting this Macro to take advantage of Excel's Spell Checker and offers suggested words.

    Any suggestions would be appreciated...

    Please Login or Register  to view this content.

    Regards,

    John
    Last edited by JJFletcher; 07-18-2019 at 08:15 AM.
    Reply With QuoteRegister To Reply
  2. 07-11-2019, 01:22 AM #2
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Spell Check for my UserForm TextBox2

    Hello JJFletcher,

    Please see this Link.

    Regards.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Reply With QuoteRegister To Reply
  3. 07-11-2019, 01:44 AM #3
    JJFletcher
    JJFletcher is offline
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    985

    Re: Spell Check for my UserForm TextBox2

    Hi Winon,

    Thanks for the feedback - I appreciate that.

    The suggested code seems to enable the Spell Check feature but for the entire UserForm - I only want to target TextBox2...

    I will continue my search - It is needed very much

    Regards,

    John
    Reply With QuoteRegister To Reply
  4. 07-11-2019, 11:14 AM #4
    JJFletcher
    JJFletcher is offline
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    985

    Re: Spell Check for my UserForm TextBox2

    Thank You Partner 352,

    Your suggested solution is basically Identical to what I already have 

    Please Login or Register  to view this content.
    Regards,

    John
    Reply With QuoteRegister To Reply
  5. 07-11-2019, 11:25 AM #5
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Spell Check for my UserForm TextBox2

    Hello JJFletcher,

    Hi John, could you please attach a sample of the Workbook in which the Code checks the whole Userform instead of Textbox1?

    Regards
    Reply With QuoteRegister To Reply
  6. 07-13-2019, 06:42 AM #6
    JJFletcher
    JJFletcher is offline
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    985

    Re: Spell Check for my UserForm TextBox2

    Hi Winon,

    I think I will abandon that approach and move forward with a more usable and simpler code..

    This seems to do the spell check very well, however I get a dialog box after the TexBox2 has been checked saying

    Capture.JPG

    Any suggestions would be appreciated 

    Please Login or Register  to view this content.
    Best Regards,

    John
    Last edited by JJFletcher; 07-13-2019 at 02:26 PM.
    Reply With QuoteRegister To Reply
  7. 07-13-2019, 02:30 PM #7
    JJFletcher
    JJFletcher is offline
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    985

    Re: Spell Check for my UserForm TextBox2

    Sorry, duplicate of above!
    Last edited by JJFletcher; 07-13-2019 at 03:05 PM.
    Reply With QuoteRegister To Reply
  8. 07-14-2019, 12:35 AM #8
    JJFletcher
    JJFletcher is offline
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    985

    Re: Spell Check for my UserForm TextBox2

    Hello All,

    I have changed the code and when the Check Spelling is completed the Spell Check produces this MSG

    Attachment 632229

    Is there a way to use the below code to prevent the MSG box from launching when the Spell Check is finished??

    Please Login or Register  to view this content.
    Regards,

    John
    Reply With QuoteRegister To Reply
  9. 07-14-2019, 11:43 AM #9
    JJFletcher
    JJFletcher is offline
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    985

    Re: Spell Check for my UserForm TextBox2

    Hi backerman2+,

    You have solved the issue - Outstanding Code

    Please Login or Register  to view this content.
    backerman2+ by far the best coder ever!!!

    Regards,

    John
    Reply With QuoteRegister To Reply
  10. 07-15-2019, 05:13 PM #10
    JJFletcher
    JJFletcher is offline
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    985

    Re: Spell Check for my UserForm TextBox2

    Hello Everyone,

    The below code works great!!! - I wanted to know what changes can be made to the code so the misspelled words are also highlighted in TextBox2... I have been researching this and it seems tat this may not be possible for a TextBox...

    Any thoughts???

    Please Login or Register  to view this content.


    Regards,

    John
    Reply With QuoteRegister To Reply
  11. 07-18-2019, 07:55 AM #11
    JJFletcher
    JJFletcher is offline
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    985

    Re: Spell Check for my UserForm TextBox2

    Hello Everyone,

    Is it possible to modify the code so that it opens up in the center of the excel application?

    Any thoughts???


    Please Login or Register  to view this content.

    Regards,

    John
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. [SOLVED] Spell Check a Userform in Excel using Word
    By Adangelo in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-10-2017, 11:53 AM
  3. How to minus textbox1.value from textbox2.value userform
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2017, 07:55 AM
  4. How to detect Spell Check activated - or - exit sub when you press cancel on Spell Check
    By tv69 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2014, 11:01 AM
  5. [SOLVED] Sort by name Userform.....Textbox1, Textbox2, Textbox3, Textbox4
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2014, 07:53 AM
  6. [SOLVED] Userform Textbox1 = Val(Textbox2.Value) / 2
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-14-2013, 09:37 AM
  7. [SOLVED] Calculate with Decimal in UserForm (Texbox1 = Textbox2 + Texbox3)
    By johan12 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-29-2012, 03:45 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1