Saturday, October 6, 2012
VBA Proofing - Add AutoCorrect Entry
Sub Automatically_Add_AutoCorrect_Entry()
'______________________________________
'
' This VBA macro adds an AutoCorrect Entry
' For example, "vba macro" becomes "VBA macro"
' This quick macro works in Word
'______________________________________
'
AutoCorrect.Entries.Add Name:="vba macro", Value:="VBA macro"
With AutoCorrect
.ReplaceText = True
End With
End Sub
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
You may comment or show me other VBA tricks, but don't rest assured I'll always reply because I only have 24 hours in a day's hard work, and only a few minutes a week to update this blog... I'll try my best though...