SpellingOptions.UserDict Property

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  Sub SpecialWord()

Application.SpellingOptions.<strong class="bterm">UserDict</strong> = "Custom1.dic"
MsgBox "The custom dictionary is currently set to: " _
    &amp; Application.SpellingOptions.<strong class="bterm">UserDict</strong>



End Sub

See Also