VBA Auto spelling

[Mugiwara]

Hi,

Is it possible to have a VBA macro for auto spelling check.
Kindly advise, as I am new.

Thank you in advance

 

[igold]

Other than using the F7 key to initiate the built in Spell Checker which I think would be the preferred method.
If you want a macro, does this help you at all. On the first run it will highlight and tell you which words and where that are misspelled. If you run it again (after correcting the spelling) it will remove the highlights and confirm that it did not find any errors.

Sub BadSpelling()

    Dim spl, cel As Range, i As Long, str As String, loc As String
    
    For Each cel In ActiveSheet.UsedRange
        cel.Style = "Normal"
        If Not Application.CheckSpelling(word:=cel.Text) Then
            cel.Style = "Note"
            spl = Split(cel, " ")
            For i = 0 To UBound(spl)
                If Not Application.CheckSpelling(word:=spl(i)) Then
                    loc = cel.Address(False, False)
                    str = str & UCase(spl(i)) & vbTab & " in cell " & loc & vbNewLine
                End If
            Next
        End If
    Next cel
    If str = "" Then str = "Spell Check Complete"
    MsgBox str
    
End Sub