Useful VBA Macros for Excel and Word
A compendium of some of my old VBA macros from the most annoying and simple ones to those that defy you at the end of a long day. I had to build the macros to deal with the demands of my job to manipulate strings, cells and files and this blog is a way to sort the most useful macros scattered all over my disks. I am not a professional programmer though, so I will accept absolutely no liability for any damage!
Showing posts with label AutoCorrect. Show all posts
Showing posts with label AutoCorrect. Show all posts
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:
Posts (Atom)