SpellingOptions.UserDict Property (Excel)
Instructs Microsoft Excel to create a custom dictionary to which new words can be added to, when performing spelling checks on a worksheet. Read/write String.
Syntax
expression .UserDict
expression A variable that represents a SpellingOptions object.
Example
This example instructs Microsoft Excel to create custom dictionary called "Custom1.dic" in the spelling options feature and notifies the user.
Sub SpecialWord()
Application.SpellingOptions.UserDict = "Custom1.dic"
MsgBox "The custom dictionary is currently set to: " _
& Application.SpellingOptions.UserDict
End Sub