Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Sep 2008
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Run spell check from code (2002)

    I have created a form in Excel and I would like to run spell check from a button on the form. My active cell on the worksheet is

    ActiveCell.Offset(0, 5) = Comment.Value

    Any suggestions on the code I should use for the button.

    Thanks.

    Paul

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Run spell check from code (2002)

    The Range and Selection objects have a CheckSpelling method:

    Range("B35").CheckSpelling
    or
    Selection.CheckSpelling

    If you type CheckSpelling in the Visual Basic Editor and press F1 you'll get help on this method (it also applies to the Application and Worksheet objects).

Posting Permissions

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