SpellingOptions.UserDict Property

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.

Visual Basic for Applications
`Sub SpecialWord() Application.SpellingOptions.UserDict = "Custom1.dic" MsgBox "The custom dictionary is currently set to: " _ & Application.SpellingOptions.UserDict End Sub`

user user dict userdict userdict property

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.