| Autocorrect is a feature of Excel that's used for correcting typing mistakes but you can also use this feature to support shortcuts.
For example if you type in tbd you can get Excel to change it to To be determined. If you use the macro recorder while setting this up you can see the VBA code you'll need to do auto corrections. I will look something like Applcation.Autocorrect... This will allow you to support specific autocorrections or even load them from a spreadsheet. The following is an example. |