none
checkspelling continue message RRS feed

  • Question

  • I am using vba in EXCEL and trying to shutoff the continue message box but I can not find any documentation for a switch to shut it off or?

    I am trying to spell check only one Cell on a sheet.

    Best regards

    James Bowen

    Wednesday, June 17, 2015 10:45 PM

Answers

  • Hi James,

    As far as I know, excel object model doesn’t provide the way to disable the continue message box.

    On the other hand, we also could use Application.CheckSpelling method to check the word spelling. For this way, we could get the spelling suggestions (add word reference, Word.Applicaiton.GetSepllingSuggestions(text))

    Regards

    Starain


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, June 19, 2015 3:19 AM
    Moderator

All replies

  • Hi James,

    1) What does "shutoff the continue message box" mean?  I cannot understand what you say.
    2) What is the message box?  Does it appear by your code(VBA)?
        Would you show us a screenshot of the message box?

    Regards,
    • Edited by Ashidacchi Wednesday, June 17, 2015 11:47 PM
    Wednesday, June 17, 2015 11:46 PM
  • Here is the screenshot you requested.

    The message box request is to continue spell checking the rest of the sheet.

    Is their away to stop the continuation message box from appearing using a switch using a True or Faults?

    Can I force a "No" to the stop the spell checker from checking the entire sheet?

    I hope this is a bit clearer.

    Part of the code

      Cells(giNewRowNum, 11).Value = txtDescription.Value
      Cells(giNewRowNum, 11).CheckSpelling

    Here is how to test it.

    Open a new sheet.

    Write "test" in cell A1.

    Write "tast" in cell A2.

    Select cell A2.

    Run Spell checker.

    Select Change Button (change tast to test)it will then opens a message box to continue checking sheet.

    that is what I want to shut off using VBA code.

    Thursday, June 18, 2015 9:44 PM
  • Hi James,

    As far as I know, excel object model doesn’t provide the way to disable the continue message box.

    On the other hand, we also could use Application.CheckSpelling method to check the word spelling. For this way, we could get the spelling suggestions (add word reference, Word.Applicaiton.GetSepllingSuggestions(text))

    Regards

    Starain


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, June 19, 2015 3:19 AM
    Moderator
  • Hi James and Starain,

    I believe Starain's answer(Application.CheckSpelling method) is perfect!
    I've tried to make a sample using "Application.CheckSpelling".

    When clicked a button [btn_CheckSpelling], check column 1 and put OK/NG on column 2, within row 2-11.

    [code]
    --------------------------
    Private Sub btn_CheckSpelling_Click()
        Worksheets("Sheet1").Select
        Dim myValue As String
        Dim myRow As Integer
        For myRow = 2 To 11
            myValue = Cells(myRow, 1).Value
            If Application.CheckSpelling(myValue) = True Then
                Cells(myRow, 2).Value = "OK"
            Else
                Cells(myRow, 2).Value = "NG"
            End If
        Next
    End Sub
    --------------------------

    Best regards,
    • Edited by Ashidacchi Friday, June 19, 2015 6:49 AM
    Friday, June 19, 2015 6:48 AM