Auto spell check VBA macro in Excel

[NithyaAv]

Hello MrExcel,

I need to write a macro which will auto spell check as we write in the Excel (Dynamic spell check just like in Word). I know that we have this feature in latest versions of Excel , but we are currently using a older version and hence to customize the feature.
Please do let me know how to implement this macro.

Thanks in advance.

 

[CalcSux78]

Welcome to the forum!

On the sheet you want to check, Right-Click the sheet name and select View Code and paste one of these (NOT BOTH)

Check everywhere on sheet except for special range:

Private Sub Worksheet_Change(ByVal Target As Range)

Dim rNoSpell As Range       'range to not check spelling
Set rNoSpell = [A1:A4].EntireRow


If Intersect(Target, rNoSpell) Is Nothing Then
    'change occurs outside protected area
    Target.CheckSpelling
End If
End Sub

Check everywhere on the sheet:

Private Sub Worksheet_Change(ByVal Target As Range)
'check everything on this sheet
Target.CheckSpelling
End Sub